Fine point of Triggers on fields and OR conditions

I've been asked to write some triggers in Oracle.

Traditionally, I have used standard SQL. Or functions and procedures.
So I don't dream in trigger code.

I'm wondering about specifying fields in the trigger.

Take this example from Oracle docs.

CREATE TRIGGER hr.salary_check

   BEFORE INSERT OR UPDATE OF salary, job_id

        ON hr.employees
   FOR EACH ROW
....

This lists:
Before UPDATE OF salary, job_id

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

Or, does it mean that BOTH must be updated (AND condition)

???

Thanks a lot Received on Fri May 26 2006 - 01:27:53 CEST