What is bulk collections?
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 |
Can primary key be changed?
Write a sql select query that only returns each name only once from a table?
Why self join is used in sql?
What is varchar example?
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
How to rename a table?
What are all the difference between Like and Contains ?
Do we need to create index on primary key?
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.
Differentiate between % rowtype and type record.
Explain the purpose of %type and %rowtype data types?