Does this look right? if not, what changes are needed to bemade?
Q: Modify the trigger in Assignment 9-2 as needed. Add code tocheck whether the DTRECD column already has a date in it and is nowbeing set to NULL.
A: CREATE OR REPLACE TRIGGER bb_reqfill_trg
AFTER UPDATE OF dtrecd ON bb_product_request
FOR EACH ROW
BEGIN IF :OLD.dtrecd IS NULL THEN
UPDATE bb_product
SET
stock = stock + :NEW.qty
WHERE idProduct = :NEW.idProduct;
END IF;
END;
Expert Answer
An answer will be send to you shortly. . . . .