Re: Fine point of Triggers on fields and OR conditions

Thanks Mark. I did find that out last night, after making the post.

I was hoping that someone would have a quick answer, given that I couldn't find anything about this in the online docs.

Mark D Powell wrote:
> >> 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 - 15:45:09 CEST