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

From: R. Nettleton <oradba_n_az_at_excite.com>
Date: Fri, 17 Dec 1999 15:24:32 -0700
Message-ID: <83ed7d$6nl$1@nnrp03.primenet.com>

I guess I should have been more specific. We have a table in place already with a few million rows. We would like to find out (within a date range) the date/time a record was inserted. I understand I can add a new column and use SYSDATE but I'm curious about the rows already there...with no date column in place using SYSDATE.

Thanks

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:945467943.8842.0.pluto.d4ee154e_at_news.demon.nl...
> The usual solution to this is to have a timestamp column in the table
which
> has as default value sysdate.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> R. Nettleton <oradba_n_az_at_excite.com> wrote in message
> news:83e73j$5kv$1_at_nnrp03.primenet.com...
> > I need to find out (if possible) how to get the date and time when a row
> was
> > inserted.
> >
> >
> > Ron N.
> >
> >
>
>
Received on Fri Dec 17 1999 - 16:24:32 CST