Interested to Buy Any Domain ? << Click Here >> for more details...
What is bulk collections?
- 2 Answers
- 7712 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 |
Talk about views
What is the difference between nested table and varray?
What is a file delimiter?
Which are the different case manipulation functions in sql?
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
What is a REF CURSOR? Compare strong and week ref cursor types.
What is sql exception?
What is the difference between python and sql?
How to run sql*plus commands in sql developer?
What does (*) mean in sql?
What do you mean by “trigger” in sql?
What is the largest value that can be stored in a byte data field?
-
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)
