How To Open and Close an Explicit Cursor
Q
How To Open and Close an Explicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL
✍: FYIcenter.com
A
An existing cursor can be opened or closed by the OPEN or CLOSE 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
OPEN c_list;
OPEN t_list;
CLOSE c_list;
CLOSE t_list;
END;
/
2007-04-29, 5007👍, 0💬
Related Topics:
