Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Newbie question.
Not without a ton of work. Theoretically you could use logminer to view all
the transactions to find when each row was created, but it would be a ton of
work. Much simpler to add a column and a trigger.
Jim
<smenard_at_avior.ca> wrote in message
news:20020913.132243.1605894428.21012_at_avior.ca...
> Is there a way to find the date when a record in a table is insert or
> modified without a row (creation or modifcation date) in the table?
>
> Exmple i have a part number table with row part nbr:
>
> row ,spec,cost, ...
>
>
> and i want to know the the creation date of a part number.
>
> Is there a way that Oracle can give the date without create a row that
> contain the date of the creation?
>
> Ths you!!!
Received on Fri Sep 13 2002 - 21:55:52 CDT