What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 67201 Views
- Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sri
This ans opt for Oracle DB
---------------------------
SYS_REFCURSOR. this is what we called Explicit cursor.
In database if u run any sql statement by default system
will create a cursor. its called "Implicit cursor".
But in PL/SQL, we r using SYS_REFCURSOR to manupulate the
multiple records. that is called Explicit cursor.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
Can you join a table to itself?
Is merge a dml statement?
how to write date and time literals? : Sql dba
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the difference between subquery and correlated query?
What is the use of function "module procedure" in pl/sql?
What does count (*) mean in sql?
Is sql workbench free?
How do you go back in sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is a constraint?
What is a dynamic query?
Explain the commit statement.
What are the different operators available in sql?
What is numeric function sql?
