Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace TRIGGER ACTUALIZAR_STOCK
- AFTER UPDATE OF STOCK ON PRODUCTO FOR EACH ROW
- BEGIN
- UPDATE PRODUCTO
- SET STOCK = STOCK+50
- WHERE :NEW.CODIGO_BARRAS = :OLD.CODIGO_BARRAS
- AND :OLD.STOCK > 320;
- END ACTUALIZAR_STOCK;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement