• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

wh0emPah on 04/02/10

Tagged

Versions (?)

04/02/10 03:35am

 / Published in: PL/SQL

 

CREATE OR REPLACE TRIGGER P_6_5_QUANTITYCHECK AFTER
  UPDATE OR INSERT ON s_item 
  FOR EACH ROW 
BEGIN 
  IF(:NEW.quantity_shipped > :NEW.quantity) THEN 
  RAISE_APPLICATION_ERROR(-20000,'Quantity Shipped kan niet meer zijn dan quantity');
  END IF;
END P_6_5_QUANTITYCHECK;

Report this snippet   Tweet