Parm Patram

select * from &&TABLE as of timestamp to_timestamp(’&&DD-&&MON-&&YY &HOUR:00:00′,’DD-MON-YY HH24: MI: SS’) minus select * from &&TABLE;
– this will allow you to browse backward to find the time when the change occurred
alter table &TABLE enable row movement;
– row movement must be enabled for flashback queries
flashback table &TABLE to timestamp to_timestamp(’&DD-&MON-&YY &HOUR:00:00′,’DD-MON-YY HH24:Mi:SS’);