Interested to Buy Any Domain ? << Click Here >> for more details...
What is bulk collections?
- 2 Answers
- 7957 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 the result, when NULL is compared with NULL?
How is indexing done in search engines?
Can we insert data into view?
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
is mysql query is case sensitive? : Sql dba
What is the use of nvl function?
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
What are the various levels of constraints?
What are the possible values for the boolean data field?
What are stuff and replace function?
What is the maximum number of rows in sql table?
What operators deal with null?
-
Oracle (3253) - 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)
