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 sql dialect?
What does a pl/sql package consist of?
what is innodb? : Sql dba
What is error ora-12154: tns:could not resolve the connect identifier specified?
what are local and global variables and their differences? : Sql dba
What is a temp table?
what is the difference between join and union? : Sql dba
how to include numeric values in sql statements? : Sql dba
Why truncate is used in sql?
Explain the commit statement.
What is the use of sql trace?
What is rtm stands for?
How does rowid help in running a query faster?
What is a pragma statement?
What are all the common sql functions?