Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

log sysdate and user for insert and update

marcoSep 13 2011 — edited Sep 13 2011
Hi all,

I've got table t1 
select 1 as id, 1 as avalue, sysdate as dateinsert, 'marco' as userinsert, null as dateupdate, null as userupdate 
from dual
My need is to log sysdate and user for insert (columns dateinsert and userinsert) and for update (columns dateupdate and userupdate).
How do I perform it? My first guess is trigger, could you please give me some example?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2011
Added on Sep 13 2011
#insert, #log, #update, #user
4 comments
448 views