Oracle Flash back Data

Insert INTO Demo
SELECT * from demo as of Timestamp to_date (' 2015-11-16, ' yyyy-mm-dd hh24:mi ')

The data is queried to a time in the table, and then inserted.

Other SQL statements:

Select Current_scn from V$database;

SELECT * from Chg_invoice_cancel as of timestamp sysdate-5/24/60; --5 minutes before the table data

Flashback table Demo to SCN 34757567; --Flashback table to the state of an SCN

ALTER TABLE demo enable row movement; --turn this feature on to try the flashback operation.

Oracle Flash back Data