i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify?
Answers were Sorted based on User's Feedback
Answer / sureshkumar somayajula
It will use in PL/SQL. Reusability of Cursor is nothing
but "REF CURSOR".These are of 2 types.
1. Weak Ref cursor 2. Strong ref Cursor.
|Is This Answer Correct ?||9 Yes||0 No|
Answer / raghu
Ref cursor comes in PL/SQL.
You can return a ref cursor in a function.
A ref cursor is useful while returning more values.
|Is This Answer Correct ?||8 Yes||1 No|
Answer / murali
ref cursor is of pl/sql topic
the main use of Ref Cursor is we can create multiple activeset area using refcursors
|Is This Answer Correct ?||1 Yes||0 No|
Answer / nirma durra
Ref-Cursor is DataType
|Is This Answer Correct ?||0 Yes||0 No|
what are the forced views
How can check sql version from command line?
How can you tell the difference between an index and a view?
Explain 3 basic parts of a trigger.
What is the maximum number of columns in sql table?
What is synonyms?
How to know the last executed procedure?
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
What is the basic difference between a sql and stored procedure ?
What is an ndf file?
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
Which nosql database is best?