Interested to Buy Any Domain ? << Click Here >> for more details...
What is bulk collections?
- 2 Answers
- 7709 Views
- I also Faced
- E-Mail Answers
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 sqlca in db2?
What are the advantages of sql? Explain
what are the advantages of using stored procedures? : Sql dba
How bulk collect improves performance?
what are all the common sql function? : Sql dba
What is sql character function?
IF i write before / after insert / update trigger and i do rollback what will happen?
What is a pdo connection?
how to include comments in sql statements? : Sql dba
What is the life of an sql statement?
What is write ahead logging in sql server?
Does inner join remove duplicates?
-
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)
