Oracle Flashback Transaction Query

Oracle Flashback Transaction Query Version 11.2.0.3

Flashback Transaction Query Functionality Demo
Demo using the flashback_transaction_query view	SELECT operation, undo_sql, logon_user FROM flashback_transaction_query WHERE xid = HEXTORAW(<version_xid>);
	conn uwclass/uwclass CREATE TABLE t ( mycol VARCHAR2(20)); INSERT INTO t VALUES ('ABC'); COMMIT; INSERT INTO t VALUES ('DEF'); COMMIT; INSERT INTO t VALUES ('GHI'); COMMIT; SELECT versions_xid, versions_startscn, versions_endscn, versions_operation, mycol FROM t VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE; conn / as sysdba desc flashback_transaction_query set linesize 121 col operation format a10 col undo_sql format a65 -- choose the 'DEF' entry's xid SELECT operation, undo_sql, logon_user FROM flashback_transaction_query WHERE xid = HEXTORAW('0A0009005F060000'); delete from "UWCLASS"."T" where ROWID = 'AAAPHYAAGAAABgqAAB'; COMMIT; SELECT * FROM uwclass. t; SELECT versions_xid, versions_startscn, versions_endscn, versions_operation, mycol FROM uwclass.t VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE; UPDATE uwclass.t SET mycol = 'MNO' WHERE mycol = 'GHI'; INSERT INTO uwclass.t VALUES ('XYZ'); COMMIT; SELECT versions_xid, versions_startscn, versions_endscn, versions_operation, mycol FROM uwclass.t VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE;