What is bulk collections?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which tcp/ip port does sql server run on? : Sql dba

507


define data blocks ? : Sql dba

539


What is a sql instance vs database?

569


What do you mean by rowid?

533


What schema means?

516






What are analytical functions in sql?

529


How do I partition a table in sql?

531


Is pl sql useful?

535


What does plv msg allows you to do?

667


What is composite data type in pl sql?

550


What is pl sql in oracle?

569


what are date and time data types in mysql? : Sql dba

490


What is the reports view in oracle sql developer?

535


How much does sqlite cost?

549


How to use transactions efficiently : transact sql

538