Software QA (13)
SQL Server (1)
How To Define a Cursor Variable
How To Define a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL
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; /
2007-04-28, 4699👍, 0💬
What are the high-level thread states? The high-level thread states are ready, running, waiting, and...
How To Enter Binary Numbers in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want...
What is the concept of XPOINTER? XPOINTER is used to locate data within XML document. XPOINTER can p...
What’ is the sequence in which ASP.NET events are processed ? Following is the sequence in which the...
What is normalization? What are different types of normalization? It is set of rules that have been ...