Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Define a Cursor Variable
How To Define a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL
✍: 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; /
2007-04-28, 4814👍, 0💬
Popular Posts:
What is the benefit of using #define to declare a constant? Using the #define method of declaring a ...
How can we implement singleton pattern in .NET? Singleton pattern mainly focuses on having one and o...
What exactly happens when ASPX page is requested from Browser? Note: - Here the interviewer is expec...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.
Can you explain in brief how the ASP.NET authentication process works? ASP.NET does not run by itsel...