Oracle PL/SQL - Can Multiple Cursors Being Opened at the Same Time

Can Multiple Cursors Being Opened at the Same Time

Q

Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQL

✍: 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

2007-04-28, 6792👍, 0💬

How To Pass a Parameter to a Cursor
How To Pass a Parameter to a Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL When you define a cursor, you can set a formal parameter in the cursor. The formal parameter will be replaced by an actual parameter in the OPEN cursor statement. Here is a good example of a cursor with two parame... 2007-04-28, 4760👍, 0💬

What Is a Cursor Variable
What Is a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL A cursor variable is a variable of a specific REF CURSOR data type, which is a pointer to a data structure resource connects to query statement result, similar to the CURSOR data type.. The advantage of using cursor variabl... 2007-04-28, 4682👍, 0💬

How To Use an Explicit Cursor without OPEN Statements
How To Use an Explicit Cursor without OPEN Statements? - Oracle DBA FAQ - Working with Cursors in PL/SQL If you want to open a cursor and loop through its data rows in quick way, you can use the FOR ... IN ... LOOP statement in the same way as the implicit cursor. The following tutorial exercise giv... 2007-04-29, 4465👍, 0💬

How To Use FETCH Statement in a Loop
How To Use FETCH Statement in a Loop? - Oracle DBA FAQ - Working with Cursors in PL/SQL If you have a cursor opened ready to use, you can also use the FETCH statement in a loop to retrieve data from the cursor more efficiently. But you need to remember to use an EXIT statement break the loop when th... 2007-04-29, 4395👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.