Does this look right? if not, what changes are needed to be made?

Q: Modify the trigger in Assignment 9-2 as needed. Add code to check whether the DTRECD column already has a date in it and is now being 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;