Re: DateTime when a Record has changed without Trigger

Hello David
thanx for the answer.

My Problem is that I am not allowed to change the Datastructure of the User. I have only Rights to Read.

Isn't there a Internal Field like ROWID ?

Or how does the syncronisation in Oracle Works ???

Micha

"David Van Zandt" <dvanzandt_at_iquest.net> wrote in message news:39BAB557.687AD257_at_iquest.net...
> 1. Add a column with a DATE datatype; create a trigger to update the
> value to SYSDATE when the row change is committed.
>
> 2. Set up an AUDIT event on the table.
>
> HTH,
> dvz
>
> Mika wrote:
> >
> > Is there a way to get the Date/Time when a Record has changed last.
> > Or is there an other identifier to find out if a Record has been changed
> > by an other user ?
> >
> > Thanx for an answer
>
> -
Received on Sun Sep 10 2000 - 05:20:51 CDT