Skip to Main Content

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!

variables like 'Current User' 'Current Session'

545382Nov 11 2006 — edited Nov 11 2006
I am currently working on a journal for a table I want to monitor. I have created a trigger on this table that has to write a record to a journal every time the table is updated. My question how can I write variables like Current User, Current Session etc into my journal table?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2006
Added on Nov 11 2006
1 comment
267 views