ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
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@pdbdev
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 sys@pdbdev 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;
