Re: DateTime when a Record has changed ?

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 Sat Sep 09 2000 - 17:10:31 CDT