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 is the most important ddl statements in sql are?
Can you select everything, but 1 or 2 fields, without writer's cramp?
what is d diff between grant,commit,rollback n savepoint
What is dml and ddl?
How to come back in normal stage in Mutating Table if mutating table is locked or update data?
What is an Exception ? What are types of Exception ?
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
Is drop table faster than truncate?
What is the difference between distinct and unique in sql?
What is the use of primary key?
What is number function in sql?
Can we use the cursor's to create the collection in PL/SQL?