查看Oracle查询语句的源代码

==闪回版本查询==
select * from TICKETDETAIL_TEMP  as of scn 329350000;<br/>
1. 获取数据删除前的一个时间点或scn，如下：<br/>
SQL>select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') time, to_char(dbms_flashback.get_system_change_number) scn from dual;

TIME               SCN
------------------- ----------------------------------------
2010-06-29 23:03:14 1060499

2.查询该时间点（或scn）的数据，如下：<br/>
SQL> select * from t as of timestamp to_timestamp('2010-06-29 22:57:47', 'yyyy-mm-dd hh24:mi:ss'); <br/>
SQL> select * from t as of scn 1060174;