Re: Fine point of Triggers on fields and OR conditions

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 May 2006 16:47:21 -0700
Message-ID: <1148600840.954762.216730_at_38g2000cwa.googlegroups.com>


>> Does this mean that if EITHER of SALARY, or JOB_ID is updated,
the trigger will fire. (OR condition) <<

Yes, OR.

Create a simple table with 4 to 6 columns on it. Create an update trigger on two columns and have it insert a history record. Perform insert. Commit. Check to see if trigger fired.

HTH -- Mark D Powell -- Received on Fri May 26 2006 - 01:47:21 CEST

Original text of this message