Wednesday, June 5, 2019

dbms_flashback in Oracle

SQL> select * from t1;

         A        SAL
---------- ----------
         1        300
         2        500
         3        800

SQL> delete from t1;

3 rows deleted.

SQL> commit;

Commit complete.

SQL> select * from t1;

no rows selected

SQL> exec dbms_flashback.enable_at_time(sysdate-2/1440);

PL/SQL procedure successfully completed.

SQL> select * from t1;

         A        SAL
---------- ----------
         1        300
         2        500
         3        800

SQL> exec dbms_flashback.disable;

PL/SQL procedure successfully completed.

No comments:

Post a Comment