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 |
how to create a test table in your mysql server? : Sql dba
What is sql and its types?
is it possible to pass an object or table to a procedure as an argument?
Explain clause in sql?
How many disk partitions should I have?
Define SQL and state the differences between SQL and other conventional programming Languages?
which operator is used in query for pattern matching? : Sql dba
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is pls integer?
Why stored procedures are faster than query?
Difference between aggregate function and analytical function?
What are the types of triggers in sql?
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)