Basic Oracle Concepts and Programming Question: Download Oracle Database PDF
How To Define an Explicit Cursor in Oracle?
Answer:
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;
/
DECLARE
CURSOR c_list IS SELECT * FROM countries;
CURSOR t_list IS SELECT * FROM employees
WHERE employee_id = 100;
BEGIN
NULL;
END;
/
Previous Question | Next Question |
How To Loop through Data Rows in the Implicit Cursor? | How To Open and Close an Explicit Cursor in Oracle? |