Re: -- determine changing time of record

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 Received on Mon Jun 30 2003 - 10:47:02 CEST