1.

Can Multiple Cursors Being Opened At The Same Time?

Answer»

Yes, multiple cursors can be opened at the same time. See the following EXAMPLE:

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.first_name || ' ' || emp_rec.last_name); CLOSE emp_cur; CLOSE dpt_cur; END; / Department name = Administration Employee name = Steven King

Yes, multiple cursors can be opened at the same time. See the following example:


Discussion

No Comment Found

Related InterviewSolutions