What cursor type do you use to retrieve multiple recordsets?
Answers were Sorted based on User's Feedback
Answer / guest
cursor <<cursorname>> is select * from <<table name>>
Is This Answer Correct ? | 55 Yes | 16 No |
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 |
Answer / venkat
using explict cursor we process multiple rows
syn:
cursor <cur_name> is select * from <tab_name>
Is This Answer Correct ? | 3 Yes | 0 No |
What are aggregate and scalar functions?
Can we rollback truncate?
What is sql indexing?
How to move files from one directory to another in pl sql?
What are local and global variables and their differences?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
How to take user input in pl sql?
How do you create an update query?
How do you bind variables in pl sql?
What do you know by pl/sql cursors?
why we go for package? what are the advantages of using instead of seperate procuderes or functions
What are the built in functions of sql?