Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0306300517.2ecf40a_at_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.
