Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. create or replace TRIGGER ACTUALIZAR_STOCK
  2. AFTER UPDATE OF STOCK ON PRODUCTO FOR EACH ROW
  3. BEGIN
  4. UPDATE PRODUCTO
  5. SET STOCK = STOCK+50
  6. WHERE :NEW.CODIGO_BARRAS = :OLD.CODIGO_BARRAS
  7. AND :OLD.STOCK > 320;
  8.  
  9. END ACTUALIZAR_STOCK;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement