FlashBack闪回使用

SELECT *
  FROM ot_account;

DELETE FROM ot_account;

COMMIT ;

SELECT *
  FROM ot_account AS OF TIMESTAMP TO_TIMESTAMP ('2009-3-23 19:14:00',
                                                'YYYY-MM-DD HH24:MI:SS'
                                               );

INSERT INTO ot_account
   SELECT *
     FROM ot_account AS OF TIMESTAMP TO_TIMESTAMP ('2009-3-23 19:14:00',
                                                   'YYYY-MM-DD HH24:MI:SS'
                                                  );

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12712263/viewspace-578031/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12712263/viewspace-578031/