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
for each row
when(new.MEMO_3 is not null)
INSERT INTO dbeventtriggertable VALUES ('Query = where
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?
Please sign in to leave a comment.