What cursor type do you use to retrieve multiple recordsets?
Answer Posted / sri
Im sorry..sys_refcursor. can be used to pass cursors from
and to a stored procedure.
Normally we r using. CURSOR cursor_name IS SELECT...
So this is called explicit cursor.
| Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
How to get unique records from a table?
What is sqlite format?
What is exception? What are the types of exceptions?
Are subqueries faster than joins?
What is the clause we need to add in function body to return variable?
what are set operators in sql? : Sql dba
Can we use join in subquery?
what is a database lock ? : Sql dba
Does pdo prevent sql injection?
What is informix sql?
Can we insert in view in sql?
What is delimiter in pl sql?
which operator is used in query for pattern matching? : Sql dba
What are stored procedures used for?
What is a column in a table?