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
Explain what is a view?
How can a function retun more than one value in oracle with proper example?
What is the difference between sum and count in sql?
Are pl sql variables case sensitive?
Show code of a cursor for loop.
How to run pl sql program in mysql?
How many types of primary keys are there?
How many sectors are in a partition?
What is mutating error in pl sql?
What are the basic sql commands?
Is sql a scripting language?
Why are cursors used?
What is sql architecture?
Can you upgrade sql express to full sql?
Where the sql database files are stored?