advanced code snippet search

Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

mqiojfei

 / Published in: PL/SQL
 
Expand | Embed | Plain Text 
  1. CREATE OR REPLACE
  2. TRIGGER P6_6_VERHOOG_TOTAL_IN_STOCK
  3. AFTER
  4.   UPDATE OR
  5.   INSERT ON s_inventory 
  6.   FOR EACH ROW 
  7. DECLARE
  8.   v_verhoging NUMBER(10);
  9. BEGIN 
  10.   IF (updating) THEN
  11.       v_verhoging := :NEW.amount_in_stock - :OLD.amount_in_stock;
  12.     ELSE IF (inserting) THEN
  13.       v_verhoging := :NEW.amount_in_stock;
  14.     END IF;
  15.   END IF;
  16.   P5_summit_pkg.verhoog_total_in_stock(:OLD.product_id,v_verhoging);
  17.  END P6_6_VERHOOG_TOTAL_IN_STOCK;

Report this snippet  

You need to login to post a comment.