怎样通过SQL或者PL/SQL判断记录是已经committed，还是没有committed

Yong Huang

lfree's idea is interesting. FLASHBACK_TRANSACTION_QUERY may give you an undo SQL so you can infer what the data was like before the DML, although it still doesn't give you the DML SQL that was run directly. Also, due to a number of bugs, the undo_sql column of FLASHBACK_TRANSACTION_QUERY may be empty.

To solve the problem as stated in msg #17, either turning on audit or drilling redo log is needed.