We have a CURSOR then we need BULK COLLECT?
Answer / 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 |
What is the main reason behind using an index?
What is the execution plan in sql?
What are conditional predicates?
What are field types?
What is the Diff b/w Constraints and Trigeer
What is sql and explain its components?
what are the difference between clustered and a non-clustered index? : Sql dba
Can you have more than one key in a database?
What is meant by cursor in sql?
Is oracle sql free?
How global cursor can be declare with dynamic trigger ?
cursor types? explain with example programs?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)