Basic Oracle Concepts and Programming Question: Download Oracle Database PDF
How To Open and Close an Explicit Cursor in Oracle?
Answer:
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;
/
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;
/
| Previous Question | Next Question |
| How To Define an Explicit Cursor in Oracle? | How To Retrieve Data from an Explicit Cursor? |