its one type of fetching data. In oracle bulk collect pl/sql engine tells

What is bulk collections?

Question Posted / vijayakumar

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

Please Help Members By Posting Answers For Below Questions

What is synonyms?

1040

What is sql profiler in oracle?

1070

What is difference between inner join and self join?

1069

what is the difference difference between procedure and packages

10364

What is the use of function "module procedure" in pl/sql?

1183

What is trigger with example?

1066

How many sql databases can you have on one server?

1061

what is acid property in database? : Sql dba

1010

how to enter binary numbers in sql statements? : Sql dba

953

How do you use join?

921

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1170

How do you rename a table in sql?

1085

what does the t-sql command ident_current does? : Transact sql

965

What is sql*loader and what is it used for?

1121

can a stored procedure call itself or recursive stored procedure? : Sql dba

1008