New Rule: never use multiple UPDATE OF in trigger event clause about plsql-and-sql-coding-guidelines HOT 2 CLOSED

REATE OR REPLACE TRIGGER emp_trg
  BEFORE UPDATE OF ename OR UPDATE OF job 
  ON emp
  FOR EACH ROW
BEGIN
  :new.sal := :old.sal*2;
END;
/

set echo on
select * from emp where empno = 7788;
update emp set ename = 'hallo' where empno = 7788;
select * from emp where empno = 7788;
rollback;
select * from emp where empno = 7788;
update emp set job = 'hallo' where empno = 7788;
select * from emp where empno = 7788;
rollback;
select * from emp where empno = 7788;

SQL> set echo on
SQL> select * from emp where empno = 7788;

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7788 SCOTT      ANALYST         7566 19.04.1987 00:00:00       3000                    20

SQL> update emp set ename = 'hallo' where empno = 7788;

1 row updated.

SQL> select * from emp where empno = 7788;

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7788 hallo      ANALYST         7566 19.04.1987 00:00:00       3000                    20

SQL> rollback;

Rollback complete.

SQL> select * from emp where empno = 7788;

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7788 SCOTT      ANALYST         7566 19.04.1987 00:00:00       3000                    20

SQL> update emp set job = 'hallo' where empno = 7788;

1 row updated.

SQL> select * from emp where empno = 7788;

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7788 SCOTT      hallo           7566 19.04.1987 00:00:00       6000                    20

SQL> rollback;

Rollback complete.

SQL> select * from emp where empno = 7788;

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7788 SCOTT      ANALYST         7566 19.04.1987 00:00:00       3000                    20

CREATE OR REPLACE TRIGGER myTrigger
  BEFORE UPDATE OF firstName OR UPDATE OF lastName -- Noncompliant - will *only* be triggered on updates of lastName!
  ON myTable
  FOR EACH ROW
BEGIN
  NULL;
END;
/

CREATE OR REPLACE TRIGGER myTrigger
  BEFORE UPDATE OF firstName, lastName             -- Compliant - triggered on updates of firstName or/and lastName
  ON myTable
  FOR EACH ROW
BEGIN
  NULL;
END;
/