Oracle Database Interview Question:

How To Define an Explicit Cursor in Oracle?

Submitted by: Administrator

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;
/

Submitted by: Administrator