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 “go” in t-sql? : Transact sql
how to create a new table in mysql? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Is primary key a clustered index?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
what is datawarehouse? : Sql dba
In a distributed database system, can we execute two queries simultaneously?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Does pl sql work in mysql?
Does view contain data?
What is multiple partition?
How do you write an inner join query?
What is the need of merge statement?
What is crud stand for?