Parm Patram

select ename,sal, versions_xid,versions_startscn,versions_endscn
from scott.emp versions
between scn minvalue and maxvalue
/

SELECT UNDO_SQL
FROM FLASHBACK_TRANSACTION_QUERY
WHERE XID = ‘01000400D3110000′
/