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