Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why is the cursor important?
Does sql*plus have a pl/sql engine?
How does rowid help in running a query faster?
What is the use of non clustered index?
What is output spooling in sql*plus?
what is a unique key ? : Sql dba
What are instead of triggers?
How do I turn a list into a table?
Mention what does plv msg allows you to do?
What are pl sql procedures?
Can we call dml statement in function?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is the benefit of foreign key?
Which one is better sql or oracle?
What are different types of keys?
