Listing B

SQL> SELECT ROWID
  2  FROM SCOTT.parts
  3  WHERE partid = 7032;



ROWID                                                                           

------------------                                                              

AAAM1TAAEAAAAGoAAA                                                              



SQL> col operation format a10

SQL> colcommit_time format a25

SQL>



SQL> SELECT logon_user, operation,
  2    TO_CHAR(commit_timestamp, 'DD-MON-YY HH24:MI:SS')
 commit_time
  3  FROM flashback_transaction_query
  4  WHERE row_id = 'AAAM1TAAEAAAAGoAAA'
  5  ORDER BY commit_time;



LOGON_USER                     OPERATION  COMMIT_TIME                      

------------------------------ ---------- -------------------------             

SCOTT                          INSERT     03-MAY-06 10:51:07                    

HGCOGGS                        UPDATE     03-MAY-06 10:52:23                    

CSPACELY                       UPDATE     03-MAY-06 10:53:14                    

HGCOGGS                        UPDATE     03-MAY-06 10:53:47