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
differentiate between float and double. : Sql dba
Is json a nosql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Which table is left in left join?
what is top in tsql? : Transact sql
What trigger means?
What is the current version of sql?
Which table is left in join?
What are different types of sql?
Can we use delete in merge statement?
Can we insert in sql function?
how to add a new column to an existing table in mysql? : Sql dba
What is delete command in sql?
Explain select statements in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?