Oracle闪回查询,可以查询特定时间点的数据快照。
示例:
select * from user.fundbalance as of timestamp sysdate - 1/24 ;
select * from user.fundbalance as of timestamp sysdate - 1/24 t where t.acctno = '123456';
Oracle闪回查询,可以查询特定时间点的数据快照。
示例:
select * from user.fundbalance as of timestamp sysdate - 1/24 ;
select * from user.fundbalance as of timestamp sysdate - 1/24 t where t.acctno = '123456';