Open Multiple Cursors at the Same Time in Oracle

Q

Can Multiple Cursors Being Opened at the Same Time in Oracle?

✍: FYIcenter.com

A

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

 

Working with Cursors in Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-16, 143👍, 0💬