Oracle3 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. ORACLE 무료 모니터링 보호되어 있는 글 입니다. 2023. 11. 25. 이전 1 다음