분류 전체보기102 백업 관련 2023. 12. 7. 디비안 세미나 - part2 확장성이 우수한 데이터모델 출처) https://cafe.naver.com/dbian/7210 확장성이 우수한 데이터모델 (세미나 발표 자료) 대한민국 모임의 시작, 네이버 카페 cafe.naver.com 2023. 12. 6. ORACLE MULTI CURSOR CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR emp_cur IS SELECT * FROM employees; emp_rec employees%ROWTYPE; CURSOR dpt_cur IS SELECT * FROM departments; dpt_rec departments%ROWTYPE; BEGIN OPEN emp_cur; OPEN dpt_cur; FETCH emp_cur INTO emp_rec; FETCH dpt_cur INTO dpt_rec; DBMS_OUTPUT.PUT_LINE('Department name = ' || dpt_rec.department_name); DBMS_OUTPUT.PUT_LINE('Employee name = ' || emp_rec... 2023. 11. 28. ORACLE FOR LOOP FOR row IN dml_statement LOOP (statement block with row.field) END LOOP; BEGIN FOR row IN (SELECT * FROM employees WHERE manager_id = 101) LOOP DBMS_OUTPUT.PUT_LINE('Name = ' || row.last_name); END LOOP; END; / Name = Greenberg Name = Whalen Name = Mavris Name = Baer Name = Higgins 2023. 11. 27. 이전 1 ··· 13 14 15 16 17 18 19 ··· 26 다음