FLASHBACK TABLE

Posted on Posted in Uncategorized

select * from REGION_ANI as of timestamp to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’);– as per old version(before commit)

select * from REGION_ANI as of timestamp to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’)
minus
select * from REGION_ANI — deleted rows

Leave a Reply

Your email address will not be published. Required fields are marked *

÷ 2 = 2