| |
GeekInterview.com > Tech FAQs > PL/SQL
| Print | |
Question: Difference between a cursor and reference cursor
|
| August 08, 2005 03:24:54 |
#1 |
| abina |
Member Since: Visitor Total Comments: N/A |
RE: Difference between a cursor and reference cursor
|
A REF CURSOR have a return type and it as 2 type Strongly Typed Cursor and Weakly Typed Cursor
but Cursor doesn't have return type
Ex:
TYPE ref_type_name IS REF CURSOR RETURN return_type;
return_type represents a record in the database
DECLARE TYPE EmpCurType IS REF CURSOR RETURN emp%ROWTYPE;
|
| |
Back To Question | |
