Re: Help for an Oracle Newbie

From: DA Morgan <>
Date: Sun, 24 Aug 2008 13:20:58 -0700
Message-ID: <>

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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sun Aug 24 2008 - 15:20:58 CDT

Original text of this message