...
2. The conflict will be resolved. The OVERWRITE removes the "AMOUNT_RECEIVED IS NULL" from the where WHERE clause to enable the update to proceed. The command console will no longer show the conflict. Note the Conflicts counter for table OE.SALES shows 1.
...
3. Compare both tables on source and target and verify that they are the same. The value for amount_received for prod_id 101 should be 120 on both source and target.
| No Format |
|---|
SQL> select * from sales; PROD_ID CUST_ID QUANTITY_SOLD AMOUNT_SOLD AMOUNT_RECEIVED SALES_STAT ---------- ---------- ------------- ----------- --------------- ---------- 101 201 233 233 1299 120 OVERDUE 102 301 30 30 1099 1099 PAID 103 401 30 30 120 120 PAID 104 401 40 40 160 OVERDUE |