Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> saving username and sysdate on insert/update

saving username and sysdate on insert/update

From: johnny <johnny_at_sra.at>
Date: Sat, 17 Apr 1999 20:33:19 +0200
Message-ID: <3718D3EF.7A71C1FE@sra.at>


hello,
i want to save the username and the time in the record which the user has updated or inserted.
therefor i've got the following cols:
adddte .. should hold the date/time of record-creation (solved it by defaultvalue)

upddte .. should hold the date/time of last update
addusr .. should hold the username who inserted the record
updusr .. should hold the username who updated the record last

anybody has any suggestions?

thanks in advance
johnny Received on Sat Apr 17 1999 - 13:33:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US