闪回查询用法:1.select * from test as of timestamp to_timestamp('2014/05/2719:17:00','yyyy/mm/dd hh24:mi:ss'); 2.select * from t_emp as of timestamp sysdate-30/1440;说明:1440指的是60*24=1440分钟。30/1440即30分钟前。
