Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How do you exit in sql?

1108


What are the set operators in sql?

1072


Does a user_objects view have an entry for a trigger?

1011


What is a record in a database?

1062


Why we use pl sql?

960


What is pl/sql table? Why is it used?

1043


how to convert character strings to numeric values? : Sql dba

1106


What is scalar function in sql?

1038


Explain the difference in execution of triggers and stored procedures?

1022


What are local and global Indexes and where they are useful.

1443


Can you inner join the same table?

991


What is duration in sql profiler trace?

1079


What is an inner join sql?

1028


How do I kill a query in postgresql?

1127


What is the left table in sql?

963