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

Delete Row Button to all records of Interactive Report in Oracle Apex

 1. add 'Delete' Del column to Report Query 2. Set the Following Properties for the DEL Column Type: Link Heading: Delete Targ...