Ittichai at 14:23, 11 March 2011

2011-03-11T14:23:02Z

Ittichai: Created page with "* Sample syntax

 SQL> SELECT xid, logon_user, UNDO_SQL   2  FROM   FLASHBACK_TRANSACTION_QUERY   3  WHERE  xid = HEXTORAW('1A000400E6CB0000');  XID               -----------..."

2011-03-11T14:22:41Z

Created page with "* Sample syntax <pre> SQL> SELECT xid, logon_user, UNDO_SQL 2 FROM FLASHBACK_TRANSACTION_QUERY 3 WHERE xid = HEXTORAW('1A000400E6CB0000'); XID -----------..."

New page

* Sample syntax
<pre>
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';

</pre>

← Older revision		Revision as of 14:23, 11 March 2011
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>

−	~~</pre>~~	+	[[Category:Database_Features]]

Flashback Transaction - Revision history

Ittichai at 14:23, 11 March 2011

Ittichai: Created page with "* Sample syntax
SQL> SELECT xid, logon_user, UNDO_SQL 2 FROM FLASHBACK_TRANSACTION_QUERY 3 WHERE xid = HEXTORAW('1A000400E6CB0000'); XID -----------..."