Collections:
Other Resources:
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;
/
2016-10-17, 195👍, 0💬
Popular Posts:
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...
Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...