Collections:
Open and Close an Explicit Cursor in Oracle
How To Open and Close an Explicit Cursor in Oracle?
✍: FYIcenter.com
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
2018-07-22, 1534🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...