What is bulk collections?
Answers were Sorted based on User's Feedback
Answer / vijayakumar
its one type of fetching data. In oracle bulk collect pl/sql
engine tells sql engine to collect all rows at once.
It will improve the performance.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / viswanath
To improve the performance of the application,oracle introduce bulk bind process using collections that is in this process we are putting all sql related vales into a collections.And in this collections we are performing insert,update at a time using for all these statements.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is dcl in sql?
What are the subsets of sql?
Why do we need sharding?
what are rollup and cube in t-sql? : Transact sql
What is normalization? How many normalization forms are there?
What is db journal file?
What do you think about pl/sql?
Is primary key clustered index?
Can triggers stop a dml statement from executing on a table?
What are views in sql?
What are all the difference between Like and Contains ?
What is clustered index 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)