What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 65902 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 rollback? : Sql dba
When is a declare statement required?
Explain the significance of the & and && operators in pl sql.
Could you please provide oca (oracle 10g) dumps for my certification ?
Can we insert delete data in view?
What is the difference between inner join and natural join?
What found sql?
How do I save a stored procedure?
What is an invalid partition table?
How do you respond to dementia behavior?
Can we update views in sql?
How bulk collect improves performance?
What are all the ddl commands?
What are the different tcl commands in sql?
How does cross join work?
