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
What is difference between procedure and trigger?
what is commit? : Sql dba
What is the difference between local and global temporary table?
What is mutating error?
Differentiate between sga and pga.
What are hotfixes and patches?
What are sql procedures?
how to analyze tables with 'mysqlcheck'? : Sql dba
Explain raise_application_error.
what are all the different normalizations? : Sql dba
Is sql sequential or random?
how to check myisam tables for errors? : Sql dba
How do I quit sql?
What do you mean by “trigger” in sql?
Write the alter statement to enable all the triggers on the t.students table.
