You may not get it.

Once you know that table and action you can search the SQL in the SQL
area . But that may still give you SQL in bind variable format.(Not exact
values)

For eg: if the table is 'X' and action is UPDATE

you can search in v$sql

select sql_text,first_load_time,last_load_time from v$sql where
upper(sql_text) like 'UPDATE X%';

and match the timings with the action time.






"jayeshrshah" <oracledba-ezmlmshield-x81075484.[Email address protected]
07/07/2005 02:14 PM


To

"LazyDBA Discussion" <[Email address protected]
cc





Subject
How to get stmt while auditing?






Dear All

How to get sql statement when we keep audit on object of insert or update
?

Regards,

Jayesh shah


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page