Answer Posted / phanikumar
to retrieve all the record at a time we use BULK COLLECT
but in cursors records will be retrieved one by one in loop. cursors an time taking process .
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain what is a view?
Is not equal in sql?
What is the difference between functions, procedures, and packages in pl/sql?
How many rows can sqlite handle?
How do I pipe the output of one isql to another?
What are different types of triggers?
How to start oracle sql developer?
How do I restart sql?
Explain the uses of control file.
Why is a trigger used?
What is example of database?
What are the different tcl commands in sql?
What are different clauses used in sql?
What is the difference between truncate and drop statements?
Is and as keyword in pl sql?
