What cursor type do you use to retrieve multiple recordsets?
Answer Posted / sri
Im sorry..sys_refcursor. can be used to pass cursors from
and to a stored procedure.
Normally we r using. CURSOR cursor_name IS SELECT...
So this is called explicit cursor.
| Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
How to start the command-line sql*plus?
what is table? : Sql dba
how to write date and time literals? : Sql dba
What does the hierarchical profiler does?
How can you create an empty table from an existing table?
What are local and global Indexes and where they are useful.
What is a natural join?
How many types of index are there?
When is the explicit cursor used ?
Explain the uses of database trigger.
What is the difference between rollback and rollback to statements?
Is inner join faster than left join?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How exception is different from error?
Which is better trigger or stored procedure?