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
Hi ,
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 |
What is primary key and foreign key with example?
Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause
Write an sql query to select all records from the table?
How many sql commands are there?
Does sql require a server?
Types of optimization?
What is sqlcontext?
when a procedure /package is getting invalidated?
How much does sql cost?
i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?
What is attribute indicator in pl sql?
How many clustered indexes can you have?