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 rename in sql?
how to use regular expression in pattern match conditions? : Sql dba
What is varchar example?
What are advantages of Stored Procedures?
What is clustered, non-clustured and unique index. How many indexes can be created on a table ?
How to handle bulk data?
How do I create a sql database?
How long it takes to learn pl sql?
What is materialised View?
Can we create foreign key without primary key?
Can we create non-clustured index on a clustered index ?
What is an oracle stored procedure?
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)