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

Can primary key be changed?

0 Answers  


Write a sql select query that only returns each name only once from a table?

0 Answers  


Why self join is used in sql?

0 Answers  


What is varchar example?

0 Answers  


----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,






i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,


How to rename a table?

0 Answers  


What are all the difference between Like and Contains ?

2 Answers   LG Soft,


Do we need to create index on primary key?

0 Answers  


Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,


Differentiate between % rowtype and type record.

0 Answers  


Explain the purpose of %type and %rowtype data types?

0 Answers  


Categories