Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Newbie question.

Re: Newbie question.

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 14 Sep 2002 02:55:52 GMT
Message-ID: <Yyxg9.418675$me6.48229@sccrnsc01>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US