Answers were Sorted based on User's Feedback
Answer / 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|
Answer / viswanath
To improve the performance of the application,oracle introduce bulk bind process using collections that is in this process we are putting all sql related vales into a collections.And in this collections we are performing insert,update at a time using for all these statements.
|Is This Answer Correct ?||1 Yes||0 No|
What is data definition language?
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
What is PL/SQL Records?
What is the best partition size for windows 10?
What is composite data type in pl sql?
Define tables and fields in a database
What is optimistic concurrency control? : Transact sql
What is a natural join sql?
Difference between SUBSTR and INSTR?
What is group by in sql?
What is foreign key and example?
What is meant by truncate in sql?