Oracle data deletion statement

Oracle data deletion statement -- view the current SCN value SELECT dbms_flashback.get_system_change_number from dual; -- SELECT to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss ', to_char (DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER) as scn from dual; -- SELECT * FROM scott through the time flashback query data www.2cto.com. test as of timestamp TO_TIMESTAMP ('2017-11-17 10:25:17 ', 'yyyy-MM-DD HH: MI: ss'); -- returns data through scn select * FROM scott. test as of scn 23565583; -- flashback table tablename to timestamp xxx flashback table tablename to scn xxx -- prerequisites for flashback table -- the row movement function must be enabled for this table, you can enable and resume alter table test enable row movement before restoration;