Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger using WHEN vs. IF

659137Mar 12 2009 — edited May 12 2010
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2010
Added on Mar 12 2009
3 comments
1,101 views