Collections:
Define an Explicit Cursor in Oracle
How To Define an Explicit Cursor in Oracle?
✍: FYIcenter.com
An explicit cursor must be defined in the declaration part of a procedure or function with the CURSOR ... IS statement as shown in the following sample script:
DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE employee_id = 100; BEGIN NULL; END; /
⇒ Open and Close an Explicit Cursor in Oracle
⇐ Loop through the Implicit Cursor in Oracle
2018-07-22, 1458🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...