SHARE
TWEET

Untitled

a guest Jun 17th, 2019 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top