Databases Reference
In-Depth Information
The timed result of this execution can be seen in the following screenshot:
In step 5 and step 6, we created two custom datatypes to store the
CUST_ID
and
CUST_FIRST_NAME
. In step 7, we used these datatypes to define two corresponding
variables,
TAB_ID
and
TAB_NAME
, used to retrieve all the required values from the
CUSTOMERS TABLE
, using the
BULK COLLECT
statement.
We can then use
TAB_ID
and
TAB_NAME
in a
FORALL
loop to insert the values in the
MY_CUSTOMERS
table in a single statement execution.
The output of this execution is as follows: