Naba,
I think you need something like this
CREATE OR REPLACE TRIGGER triggername
AFTER INSERT OR UPDATE OR DELETE
ON tablename
FOR EACH ROW
WHEN (NVL(new.fldname1,old.fldname1)is not null and
NVL(new.fldname2,old.fldname2)is not null)
DECLARE
BEGIN
processing goes here
END;
hth,
Chaim
12:13
AMTo: Multiple recipients of list ORACLE-LSubject:
Database Trigger not fireing In Delete Mode
Hi all,
I have row level table trigger to
fire on DELETE or INSERT or UPDATE Mode .
It has to fire on certain condition, meaning I have a WHEN condition
also.
WHEN Condition
Title: RE: Avoding Mutation of Table trigger
Hi all,
I have row level table trigger to
fire on DELETE or INSERT or UPDATE Mode .
It has to fire
on certain condition, meaning I have a WHEN condition also.
WHEN Condition is like :
when (
NEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not