Content Comparison

REPOE@TTORCL_trg> select * from repoe.logon where logon_id =1000000 order by customer_id;
  LOGON_ID CUSTOMER_ID LOGON_DATE
---------- ----------- ------------------
   1000000      496840 31-MAR-06
   1000000      496840 31-MAR-06

REPOE@TTORCL_SRC> update repoe.logon set logon_id=logon_id*100 where logon_id =1000000;
2 rows updated.
REPOE@TTORCL_SRC> commit;
Commit complete.

REPOE@TTORCL_trg> select count(*) from repoe.logon where logon_id =1000000;
COUNT(*)
----------
0
REPOE@TTORCL_trg> select count(*) from repoe.logon where logon_id =100000000;
COUNT(*)
----------
0
REPOE@TTORCL_trg>
COUNT(*)
----------
2