What cursor type do you use to retrieve multiple recordsets?
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
What is the difference between partitioning and sharding?
Explain the difference between sql and mysql.
How is data stored on a disk?
What is the difference between local and global temporary table?
What are the limitations of sql express?
How many types of functions are there in sql?
How to pipe multiline string to isql?
Why do we need view in sql?
What are the different types of dbmss?
What is the most restrictive isolation level? : Transact sql
Can we update views in sql?
How global cursor can be declare with dynamic trigger ?
What is a subquery in sql?
Is sqlexception checked or unchecked?
What is auto increment in sql?