What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 64701 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 clause in sql?
What are the two different parts of the pl/sql packages?
what is a primary key? : Sql dba
Can we use join in subquery?
Why is partition used in sql?
how to use 'mysql' to run sql statements? : Sql dba
What is serial sql?
How do you write a subquery?
How global cursor can be declare with dynamic trigger ?
define sql delete statement ? : Sql dba
What is nested table in pl sql?
How many types of keys are there in sql?
What is sql in oracle?
What is #table in sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
