Answer Posted / ruchi
The keyword FORALL lets you run multiple DML statements
very efficiently. It can only repeat a single DML
statement, unlike a general-purpose FOR loop.
The FORALL statement issues a series of INSERT, UPDATE, or
DELETE statements, usually much faster than an equivalent
FOR loop. It requires some setup code, because each
iteration of the loop must use values from one or more
collections in its VALUES or WHERE clauses.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are nested tables?
Can sub procedure/function be called recursively?
What is the quickest way to export a table to a flat file?
Is oracle an operator?
Explain what are the advantages of views?
What privilege is needed for a user to create views in oracle?
Difference between hot backup vs. Cold backup?
What are the benefits of ordbms?
What is a read only transaction in oracle?
What is concurrency in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Is there any function in oracle similar like group_concat of mysql?
How to pass parameters to procedures in oracle?
How to create a new table in your schema?
Can a parameter be passed to a cursor?
