Home -> Usenet -> comp.databases.oracle -> User Trigger?????????????

User Trigger?????????????

From: Joe Christopher <jchristopher_at_loopexpert.com>
Date: 17 Dec 2002 09:20:39 -0800
Message-ID: <1c5371b4.0212170920.7fa423f2_at_posting.google.com> 






Hello,



I'm new to the group and have a couple of questions I was hoping
someone could help me with.



I have datestamp and current_user fields in my table.  Every time a
record has been inserted, or updated, I would like my trigger to
update the datestamp with the sysdate and the current_user with the
logged in use who made the change.  I have the datestamp trigger
working fine but am having trouble getting the user correct.



I am not too great with PL/SQL.  How can I get the user field to be
updated with the current user in my trigger?



Thanks!!!!


Joe
Received on Tue Dec 17 2002 - 18:20:39 CET












Original text of this message