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

Why do we use sql constraints? Which constraints we can use while creating database in sql?

721


What type of database is cloud sql?

778


Which join is like inner join?

762


Are subqueries better than joins?

717


How do I count records in sql?

728






what is the use of double ampersand (&&) in sql queries?

820


Which software is used for pl sql programming?

677


What is the usage of sql functions?

814


Is natural join same as inner join?

677


What is sql character function?

709


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

751


How to use sql*plus built-in timers?

764


what is log shipping? : Sql dba

822


give the syntax of grant and revoke commands? : Sql dba

800


Can you have more than one key in a database?

686