What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 64780 Views
- Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro, I also Faced
- E-Mail Answers
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
What is the execution plan in sql?
what is a composite key ? : Sql dba
What is the maximum number of rows in sql table?
Can we call dml statement in function?
How does left join work in sql?
What is the largest value that can be stored in a byte data field?
What is assignment operator in pl sql?
Mention what are the benefits of pl/sql packages?
What is write ahead logging in sql server?
What is the purpose of a sql?
How do I run sql profiler?
What is the maximum number of columns in sql table?
What is group function in sql?
What is set serveroutput on in pl sql?
Which is faster truncate or drop?
