Re: Fine point of Triggers on fields and OR conditions

>> 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 Thu May 25 2006 - 18:47:21 CDT