Re: Help for an Oracle Newbie
From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 24 Aug 2008 13:20:58 -0700
Message-ID: <1219609246.570456@bubbleator.drizzle.com>
>
> O yes it can be, if a user selects a record and updates some columns except
> lastupdated. (E.g. using Oracle Forms: query a record, update and commit.)
> In that case lastmodified will not be updated, where the record was changed!
Date: Sun, 24 Aug 2008 13:20:58 -0700
Message-ID: <1219609246.570456@bubbleator.drizzle.com>
Shakespeare wrote:
>> If it is NOT NULL then it will not be equal to the previous value.
>
> O yes it can be, if a user selects a record and updates some columns except
> lastupdated. (E.g. using Oracle Forms: query a record, update and commit.)
> In that case lastmodified will not be updated, where the record was changed!
An AFTER UPDATE trigger without an OF clause will fire no matter what is or is not updated.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Aug 24 2008 - 15:20:58 CDT