Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between bulk collect and forall
- 3 Answers
- 27643 Views
- Metric Stream, I also Faced
- E-Mail Answers
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
Can you call pl/sql package functions from within a fast formula?
What is dense_rank in sql?
how to include numeric values in sql statements? : Sql dba
what is 'trigger' in sql? : Sql dba
Explain how can you save or place your msg in a table?
What kind of join is join?
What is sql and db2?
What are schema-level triggers?
what does the t-sql command ident_incr does? : Transact sql
What does := mean in pl sql?
how to write date and time literals? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
What does the sign mean in sql?
Why truncate is used in sql?
Why commit is not used in triggers?
