Message-ID: <39BAB557.687AD257@iquest.net>
From: David Van Zandt <dvanzandt@iquest.net>
X-Mailer: Mozilla 4.73 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: DateTime when a Record has changed ?
References: <8pe2ti$1bhp$1@news.okay.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 17
Date: Sat, 09 Sep 2000 17:10:31 -0500
NNTP-Posting-Host: 204.95.254.170
X-Trace: news1.iquest.net 968537516 204.95.254.170 (Sat, 09 Sep 2000 17:11:56 EDT)
NNTP-Posting-Date: Sat, 09 Sep 2000 17:11:56 EDT


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

-