Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
SQL> update SALES set AMOUNT_RECEIVED = 60 
where SALES_STATUS = 'OVERDUE' 
and PROD_ID = 101;
commit;

 

2. The  The AMOUNT_RECEIVED column is now different on the target as what it is on the source for record in record PROD_ID = 101. On 101 on the target database it is 60 and now differs from the source database it is NULL.

 

3. Update the AMOUNT_RECEIVED for PROD_ID = 101 on the source database. On source server (dbv01) run the following SQL to update the value

...