Collections:
Define a Cursor Variable in Oracle
How To Define a Cursor Variable in Oracle?
✍: FYIcenter.com
To define cursor variable, you must decide which REF CURSOR data type to use. There are 3 ways to select a REF CURSOR data type:
The follwoing tutorial exercise defines 3 cursor variables in 3 different ways:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; TYPE any_ref IS REF CURSOR; emp_cur emp_ref; any_cur any_ref; sys_cur SYS_REFCURSOR; BEGIN NULL; END; /
⇒ Open a Cursor Variable in Oracle
⇐ What Is a Cursor Variable in Oracle
2018-07-18, 1599🔥, 0💬
Popular Posts:
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...