What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 67211 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 difference between a subquery and a join?
what are the different type of normalization? : Sql dba
How exception handling is done in advance pl/sql?
Can we use pl sql in mysql?
What are aggregate functions in sql?
What are the benefits of pl/sql packages?
How many scalar data types are supported in pl/sql?
How much ram can sql express use?
What is range partitioning?
What is the use of prepared statement?
define join and explain different type of joins? : Sql dba
What are analytic functions in sql?
What is the usage of nvl function?
tell me about various levels of constraint. : Sql dba
Is crud a cuss word?
