Collections:
Open Multiple Cursors at the Same Time in Oracle
Can Multiple Cursors Being Opened at the Same Time in Oracle?
✍: 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
⇒ Pass a Parameter to a Cursor in Oracle
⇐ Use an Explicit Cursor without OPEN Statements in Oracle
2018-04-07, 2237🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...