Re: -- determine changing time of record

avanrossem_at_hotmail.com (Andre) wrote in message news:<4d32d1be.0306302131.37898461_at_posting.google.com>...
> Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0306300517.2ecf40a@posting.google.com>...
> > sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0306300047.3fa7700_at_posting.google.com>...
> > > avanrossem_at_hotmail.com (Andre) wrote in message news:<4d32d1be.0306292241.38bbdd1d_at_posting.google.com>...
> > > > Hello all,
> > > >
> > > > In my database I have a table with records. (Yes I have!!)
> > > > Last week a record is changed, but I want to know on which date/time
> > > > that was.
> > > > Is there a oracle field in the table (like rownum) in which I can see
> > > > the time which the recoird has changed??
> > > >
> > > > (please do not answer with the sollution to add an extra "field" in
> > > > the table and let a trigger fill that field with the changingdate. It
> > > > is too late for that :-) )
> > > >
> > > >
> > > > THANKS and regards,
> > > > Andre
> > > > The Netherlands
> > >
> > >
> > > Please don't ask for advice if you don't want to implement the obvious
> > > and *ONLY* solution. Your remark 'it is too late for that' is just
> > > what is: ridiculous and utter bs. Tables can be ALTERed easily, and
> > > nothing will be affected by that: RDBMS lesson !1!. Triggers can also
> > > be added easily.
> > >
> > > Sybrand Bakker
> > > Senior Oracle DBA
>
> Hello Sybrand, I think you did not fully understand my question.
> Offcourse I know that tables can be easily altered, but thats not my problem.
>
> I will try the data mining method. Takes a lot of time, but I will try.
>
>
> Andre

crap methods are crap methods and not changing an application for political reasons is just stupid.

Sybrand Bakker
Senior Oracle DBA Received on Tue Jul 01 2003 - 11:15:08 CEST