0

Oracle Trigger (10g)

Situation:

I have a database trigger event and I would like to add a condition to
trigger the the PF. Following is the trigger.

 

create or replace trigger BRC_TRIGGERORD

AFTER insert or update of MEMO_3

on BRC_ORD

for each row

when(new.MEMO_3 is not null)

begin

INSERT INTO dbeventtriggertable VALUES ('Query = where
MEMO_3='||:new.MEMO_3);

END;

 

I want to add a where clause so that it triggers the PF for insert, update
of MEMO_3 where BRC_ORD.project_num in (select project_num from PROJECT
where client_num = 'BI'). How can this be achieved?

 

1 comment

Please sign in to leave a comment.