Hey,
CREATE OR REPLACE TRIGGER "TRI_AMOUNT_REDUCTION"
AFTER INSERT ON "PURCHASE"
FOR EACH ROW
BEGIN
IF (:NEW.CLIENTNO = 122336) THEN
:NEW.AMOUNT := AMOUNT * 0.1;
END IF;
END;
/
I have a query that selects my top client then want to pass the clientNo to the trigger. Is it a good idea to put my select statement in the trigger instead ?