Hi team,
I want to get some field values from some tables.If field values of tables changed. it must be captured.don't use trigger。
for example:
table：A fields:a1(primary key), a2,a3
table: B fields:b1(primary key),b2,b3
If table A field a2 was changed,It will be captured.If table A field was changed.I will not be captured.

I consider that use materialized view log mlog .but materialized view log mlog stored all changed records.
select * from mlog$_tw_tower_test;
TOWER_ID LONGITUDE STATION_ID MODIFY_TIME SNAPTIME$$ DMLTYPE$$ OLD_NEW$$ CHANGE_VECTOR$$ XID$$
005088430200000048918753 1112.0000000000 005002010200000027282653 2016/11/22 11:37:46 4000/1/1 U U 0000000000 2814749767128640.00
005088430200000048918753 1112.0000000000 005002010200000027282653 2016/11/22 11:37:46 4000/1/1 U N 0000000000 2814749767128640.00
005088430200000048918753 1112.0000000000 005002010200000027282653 2016/11/22 11:37:46 4000/1/1 U U 0800000000 3096357887858220.00
005088430200000048918753 1112.0000000000 005002010200000027282653 2016/11/22 11:37:46 4000/1/1 U N 0800000000 3096357887858220.00
005088430200000048918753 1112.0000000000 005002010200000027282653 2016/11/22 11:37:46 4000/1/1 U O 0002000000 1688957234458800.00
005088430200000048918753 555.0000000000 005002010200000027282653 2016/11/22 11:37:46 4000/1/1 U N 0002000000 1688957234458800.00

I just want save latest record and SNAPTIME$$ how to change update?
005088430200000048918753 555.0000000000 005002010200000027282653 2016/11/22 11:37:46 4000/1/1 U N 0002000000 1688957234458800.00


please help me.
Thanks in advance.