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

From: Kbat <kbatsche_at_yahoo.com>
Date: Sun, 19 Dec 1999 20:17:28 -0700
Message-ID: <83k6tq$5t1$1@nnrp03.primenet.com>

Duplicate the primary key from the old table into a new table and add the 'date_entered' column, default sysdate. Have the insert add the appropriate data to both tables. Then create a view that adds the date entered column to the first table.

Good Luck!

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 Sun Dec 19 1999 - 21:17:28 CST