Oracle recover accidentally deleted data

Example of accidentally deleting data after oracle Restoration: 1. select * from test_table t // query all data in t_viradsl2. Three data entries are displayed. delete test_table // delete all data in t_viradsl2, and three data entries disappear. select * from test_table t // no data. 4. insert into test_table select * from test_table as of timestamp to_Date ('2017-01-19 15:28:00 ', 'yyyy-mm-dd hh24: mi: ss ') // you have inserted the accidentally deleted data into the table www.2cto.com 5. select * from test_table t // three more data entries are displayed. Let's analyze the fourth step. Note this sentence: select * from test_table as of timestamp to_Date ('2017-01-19 15:28:00 ', 'yyyy-mm-dd hh24: mi: ss'). What do you mean by finding all the data (data snapshots) of test_table at 15:28:00 ). Author: yu_xinling