查询闪存

(1)查询目标表30分钟前的数据
select * from 目标表表名
as of timestamp sysdate-30/1440
/
(2)查询目标表2010-11-22 00:00:00时的数据
select * from 目标表表名
as of timestamp to_timestamp('2010-11-22 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
/