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
Is left join and outer join same?
What is cte?
Why do we use joins?
what is rdbms? : Sql dba
Is primary key clustered or nonclustered?
Are sql connections encrypted?
Why is a trigger used?
What is sql architecture?
What is on delete set null?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What does the hierarchical profiler does?
What is the purpose of my sql?
explain access control lists. : Sql dba
What's the difference between inner join and left join?
What is the difference between distinct and unique in sql?