Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Can Multiple Cursors Being Opened at the Same Time
Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQL
✍: FYIcenter.com
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, 7294👍, 0💬
Popular Posts:
Can you explain Forms authentication in detail ? In old ASP if you where said to create a login page...
How does one iterate through items and records in a specified block? One can use NEXT_FIELD to itera...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
What is the result of using Option Explicit? When writing your C program, you can include files in t...
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL If you want create an ar...