14:01:10 SQL> select * from aa;

        ID NAME                                     BORN
---------- ---------------------------------------- --------------
         1 lishaoqing                               01-10る-11
         1 lishaoqing                               01-11る-11
         1 lishaoqing                               01-12る-11
         1 lishaoqing                               01-1る -12

14:01:15 SQL> show user;
USER ? "SYS"
14:01:19 SQL> delete from aa;

已刪除4個資料列


14:02:36 SQL> select * from aa as of timestamp to_timestamp('20120201 14:01:32','YYYYMMDD HH:MI:SS');
select * from aa as of timestamp to_timestamp('20120201 14:01:32','YYYYMMDD HH:MI:SS')
                                              *
 ERROR 在行:1
ORA-01849:小時的數字須介于 1和 12之間


14:03:04 SQL> select * from aa as of timestamp to_timestamp('20120201 02:01:32','YYYYMMDD HH:MI:SS');

        ID NAME                                     BORN
---------- ---------------------------------------- --------------
         1 lishaoqing                               01-10る-11
         1 lishaoqing                               01-11る-11
         1 lishaoqing                               01-12る-11
         1 lishaoqing                               01-1る -12

14:03:19 SQL> insert into aa select * from aa as of timestamp to_timestamp('20120201 02:01:32','YYYYMMDD HH:MI:SS');

已建立4個資料列

14:03:54 SQL> select * from aa;

        ID NAME                                     BORN
---------- ---------------------------------------- --------------
         1 lishaoqing                               01-10月-11
         1 lishaoqing                               01-11月-11
         1 lishaoqing                               01-12月-11
         1 lishaoqing                               01-1月-12

總結：閃回版本查詢的語法如下：
SQL>select [pseudocolumns] ... /*列名
             from ....                                 /*表名
             versions between
              {scn|timestamp {expr|minvalue} and {expr|maxvalue}}
           [AS OF{scn|timestamp expr}]
            where .............
SQL>FLASHBACK TABLE
          [schema.].table
          [,[schema].table ....
          TO  {{SCN|TIMESTAMP} expr[{ENABLE|DISABLE} TRIGGERS]
           |BEFORE DROP[RENAME TO table]
           };