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.
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