BULK COLLECT INTO clause with EXECUTE IMMEDIATE statement store values - SQL Operations

Q.  You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection.
- Published on 19 Oct 15

a. Yes
b. No

ANSWER: Yes
 
The BULK sql passes an entire collection to and fro. The BULK COLLECT INTO clause is used to execute the statements immediately.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)