Difference between revisions of "Flashback Transaction"
Jump to navigation
Jump to search
(Created page with "* Sample syntax <pre> SQL> SELECT xid, logon_user, UNDO_SQL 2 FROM FLASHBACK_TRANSACTION_QUERY 3 WHERE xid = HEXTORAW('1A000400E6CB0000'); XID -----------...") |
(No difference)
|
Revision as of 09:22, 11 March 2011
- 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';
