Re: finding exactley when a record was inserted...

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 17 Dec 1999 16:06:13 -0500
Message-ID: <uc9l5ssslcd8tdq9v9p82tm2hmkiramaa9@4ax.com>

A copy of this was sent to "R. Nettleton" <oradba_n_az_at_excite.com> (if that email address didn't require changing) On Fri, 17 Dec 1999 13:40:08 -0700, you wrote:

>I need to find out (if possible) how to get the date and time when a row was
>inserted.
>
>
>Ron N.
>

You'll need to add a column to the table:

alter table T add timestamp date default sysdate;

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Dec 17 1999 - 15:06:13 CST