- -- 查看之前的数据
- -- select * from TABLE_NAME AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' MINUTE)
- create table t_table_recove --新表
- as
- select * from t_table--你操作的那张表
- as of timestamp to_timestamp('2016-06-08 11:36:53','yyyy-mm-dd hh24:mi:ss');
- --该片段来自于http://www.codesnippet.cn/detail/0707201614804.html
来源: http://www.codesnippet.cn/detail/0707201614804.html