What is diff between bulk collect and forall
- 3 Answers
- 26507 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / prabu t
Bulk collect:
*is a CLAUSE
*is used to fetch the records from the cursor.
Forall:
*is a STATEMENT
*is used to do dml operation of fetched records.
*The body of the FORALL statement is a single DML statement
-- an INSERT, UPDATE, or DELETE.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What does stand for in sql?
Define select, insert, create, delete, update, drop keywords
What are properties of the transaction?
What is rownum?
What is $$ in sql?
what is an index? : Sql dba
What is rank function in sql?
Why is a trigger used?
What is nvarchar in sql?
Explain autonomous transaction.
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
What is meaning of <> in sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
What does plv msg allows you to do?
