View the Exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.
Evaluate the following MERGE statement:
MERGE INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total);
What would be the outcome of the above statement?
A.
The ORDERS_MASTER table would contain the ORDER_IDs 1 and 2.
B.
The ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 3.
C.
The ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 4.
D.
The ORDERS_MASTER table would contain the ORDER_IDs 1, 2, 3 and 4.
create table om (i number, ii number );
create table om2 (i number, ii number );
select * from om;
select * from om2;
MERGE INTO om a
USING om2 b
ON (a.i = b.i)
WHEN MATCHED THEN
UPDATE SET a.ii = b.ii
DELETE WHERE (a.ii IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (b.i, b.ii);
insert into om values (2, 33333);
insert into om values (80, 820);