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 -> TIMESTAMP in field during INSERT operation only

TIMESTAMP in field during INSERT operation only

From: <mokat67_at_hotmail.com>
Date: Sun, 19 Jan 2003 13:03:36 GMT
Message-ID: <3e2a9ea6.2037479@news.hccnet.nl>


I need the following which should be a very easy question for most of you:

I have a table A with field B. I want to have a timestamp (Format (HH:MM:SS) in field B. The timestamp may only be insert into field B during an INSERT and not being changed anymore during an UPDATE.

Can someone give me the right syntax. Is this done by an INSERT BEFORE trigger?
Thanks Received on Sun Jan 19 2003 - 07:03:36 CST

Original text of this message

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