What is diff between bulk collect and forall
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 is pl sql code?
What are all the common sql functions?
Sql technical questions
What are the differences between implicit and explicit cursors?
What is trigger explain with example?
How to place comments in pl/sql?
What is sql not null constraint?
What does dml mean?
Explain what is sql?
What are few of the schema objects that are created using PL/SQL?
What are inner outer left and right joins in sql?
What is the maximum rows in csv?
What is difference between cursor and trigger?
what are the drivers in mysql? : Sql dba
How to select all records from the table?