I have some table and I have enabled auditing on this table. Currently, I am collecting the data about who has inserted records and at what time. Now I also want to log what was the exact query he/she used to insert the record. I created a trigger which at present only logs the user and date to audit data collection table. This is code to the trigger:
create or replace trigger auditer after insert on user01.sometab for each row insert into sys.auditlogs values(user,sysdate)
How can I use the same trigger to access the insert statement and insert that statement into the audit table? Is it even possible?