Open and Close an Explicit Cursor in Oracle

Q

How To Open and Close an Explicit Cursor in Oracle?

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

 

Retrieve Data from an Explicit Cursor in Oracle

Define an Explicit Cursor in Oracle

Working with Cursors in Oracle PL/SQL

⇑⇑ Oracle Database Tutorials

2018-07-22, 1502🔥, 0💬