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

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

514


Define join and name different types of joins?

520


Do we need to create index on primary key?

471


Explain the the delete statements in sql?

581


What are instead of triggers?

628






What is data type in database?

550


how many sql dml commands are supported by 'mysql'? : Sql dba

571


How to run sql commands in sql*plus?

591


What is difference between db2 and sql?

534


Is sqlite good enough for production?

536


What does cursor do in sql?

521


What is java sql drivermanager?

551


What is the primary key?

538


How do I install microsoft sql?

531


Differentiate between sga and pga.

676