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 -----------...") |
|||
| Line 17: | Line 17: | ||
update "ITTICHAI"."FLASHBACK_QUERY_TEST" set "ID" = '1' where ROWID = 'AAAhPhAAEAAACFOAAA'; | update "ITTICHAI"."FLASHBACK_QUERY_TEST" set "ID" = '1' where ROWID = 'AAAhPhAAEAAACFOAAA'; | ||
| + | </pre> | ||
| − | + | [[Category:Database_Features]] | |
Latest revision as of 08:23, 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';
