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
How do you exit in sql?
What are the set operators in sql?
Does a user_objects view have an entry for a trigger?
What is a record in a database?
Why we use pl sql?
What is pl/sql table? Why is it used?
how to convert character strings to numeric values? : Sql dba
What is scalar function in sql?
Explain the difference in execution of triggers and stored procedures?
What are local and global Indexes and where they are useful.
Can you inner join the same table?
What is duration in sql profiler trace?
What is an inner join sql?
How do I kill a query in postgresql?
What is the left table in sql?