What is bulk collections?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we solve sql error: ora-00904: invalid identifier?

700


What if we write return in procedure?

788


How do you optimize a stored procedure in sql?

506


What does plv msg allows you to do?

683


Why triggers are used?

557






How to use boolean type in select statement?

585


Which software is used for pl sql programming?

526


How do I debug a stored procedure?

631


What is partition in sql query?

521


What is full join in sql?

526


What is autocommit sql?

541


What is pl sql block in dbms?

532


explain the difference between delete , truncate and drop commands? : Sql dba

553


what is data integrity? : Sql dba

596


What is procedure and function?

520