Flashback Transaction

• Sample syntax

SQL> SELECT xid, logon_user, UNDO_SQL
  2  FROM   FLASHBACK_TRANSACTION_QUERY
  3  WHERE  xid = HEXTORAW('1A000400E6CB0000');

XID              
---------------- 
1A000400E6CB0000

LOGON_USER
------------------------------
ITTICHAI

UNDO_SQL
--------------------------------------------------------------------------------------------
update "ITTICHAI"."FLASHBACK_QUERY_TEST" set "ID" = '1' where ROWID = 'AAAhPhAAEAAACFOAAA';