Adding a date column in Oracle 9i

From: <laredotornado_at_zipmail.com>
Date: 5 May 2006 10:47:36 -0700
Message-ID: <1146851256.416441.271790@y43g2000cwc.googlegroups.com>

Hi,

How, if at all, could I add a column to a table in Oracle 9i in which the column would record time and date, and its default value would be the time the row was inserted. My objective is to avoid editing SQL statements to include "SYSDATE" calls. What I would like is taht whenever a row is INSERTED, the time the row was inserted is recorded in this new column I create.

I don't want anything to happen on UPDATEs.

Thanks, - Dave Received on Fri May 05 2006 - 12:47:36 CDT