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
Explain what is table in a database?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the difference between view and stored procedure?
What is a primary key called that is made up of more than one field?
What are instead of triggers?
Does truncate release storage space?
How do you get column names only for a table (sql server)?
Why coalesce is used in sql?
what is sql? : Sql dba
Difference between truncate, delete and drop commands?
how to get a list of all tables in a database? : Sql dba
How to change sql*plus system settings?
How do you write a subquery?
What is on delete restrict?
What is difference sql and mysql?