当前位置: 代码迷 >> Oracle开发 >> select * from dba_source as of timestamp sysdate-1/12解决方案
  详细解决方案

select * from dba_source as of timestamp sysdate-1/12解决方案

热度:439   发布时间:2016-04-24 07:56:08.0
select * from dba_source as of timestamp sysdate-1/12
as   of   timestamp   sysdate-1/12     这是什么用法

------解决方案--------------------
是FLASHBACK QUERY

9i以后提供的功能,功能是查询以前某时刻的表的数据
------解决方案--------------------
查询2个小时之前,该表的数据状态
flashquery闪回查询
------解决方案--------------------
as of timestamp sysdate-1/12 看不懂,
如果要查表t5001 的昨天的sql 操作如何写语句?
select * from t5001 as of timestamp sysdate-1/12
  相关解决方案