Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is bulk collections?

Answers were Sorted based on User's Feedback



What is bulk collections?..

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

What is bulk collections?..

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

Post New Answer

More SQL PLSQL Interview Questions

What is data definition language?

0 Answers  


I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,


What is PL/SQL Records?

0 Answers  


What is the best partition size for windows 10?

0 Answers  


What is composite data type in pl sql?

0 Answers  






Define tables and fields in a database

0 Answers  


What is optimistic concurrency control? : Transact sql

0 Answers  


What is a natural join sql?

0 Answers  


Difference between SUBSTR and INSTR?

3 Answers  


What is group by in sql?

0 Answers  


What is foreign key and example?

0 Answers  


What is meant by truncate in sql?

0 Answers  






Categories