Trigger using WHEN vs. IF
659137Mar 12 2009 — edited May 12 2010I have two triggers that serves the same purpose; I just want to solicite an idea which trigger is more effecient when the table is heavily used (DML wise).
Triger 1: Using WHEN clause.
----------------------------
TRIGGER test_123
before insert on excep_table
for each row
WHEN (new.excep_code is not null)
DECLARE
BEGIN
:new.excep_code_message := get_excep_message(:new.excep_code);
END;
Triger 2: Using the trigger body
--------------------------------
TRIGGER test_123
before insert on excep_table
for each row
DECLARE
BEGIN
IF (:new.excep_code is not null) THEN
:new.excep_code_message := get_excep_message(:new.excep_code);
END IF;
END;
Appreciate any inputs.