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

> 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

AFAIK there is no way to get the insert-date if no date-column is provided by yourself
for this purpose...

Regards, Stephan

--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------