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, 1502🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...