Advertisement
fkeles

Untitled

Apr 13th, 2023
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.29 KB | Source Code | 0 0
  1. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
  2.  
  3. INSERT INTO DEMO_TABLE (t_data) VALUES ('test data 99');
  4. UPDATE DEMO_TABLE
  5.    SET t_data = 'test data X'
  6.  WHERE t_id <= 3;
  7. commit;
  8.  
  9. SELECT * FROM flashback_transaction_query
  10. WHERE 1=1
  11. AND logon_user = 'ADMIN'
  12. AND TABLE_NAME = 'DEMO_TABLE';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement