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 -> Re: Oracle newbie question

Re: Oracle newbie question

From: Rich Woods <rawoods_at_concentric.net>
Date: 1997/06/13
Message-ID: <33A1DC02.443E@concentric.net>#1/1

Alex Kac wrote:
>
> I'm kind of new to Oracle, having used other SQL Dbs before.
>
> My question is how would one provide an automatic time/date stamp on a
> column as a row is being inserted?
>
> I thought of using Triggers to do this, but thought that there must be a
> more correct way. Thanks.

You could also declare a default value for the column at the table level.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Fri Jun 13 1997 - 00:00:00 CDT

Original text of this message

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