NO Trigger hind /*+NO_TRIGGER */
in Some recent releases of Oracle, a new hint /*+ NO_TRIGGER */ is introduced
This hint prevents triggers to be fired while the statement is being executed without disabling the trigger. Using this hint could be hazardous, It is good testing and debugging hint.
Example
SQL>create or replace trigger test_trigger
before insert on emp
for each row
begin
:new.sal:= :new.sal +1;
end;/
Trigger created.
This trigger will add (1) to the salary that the user enters
SQL> INSERT INTO EMP (EMPNO, SAL) VALUES (1,999);
1 row created.
SQL> select empno, sal from emp;
EMPNO
SAL
---------- ----------
1 1000
SQL> INSERT /*+NO_TRIGGER */INTO EMP (EMPNO, SAL) VALUES (2,999);
1 row created.
SQL> select empno, sal from emp;
EMPNO
SAL
---------- ----------
1 999
Trigger bypassed