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 TRIGGER P6_4_UPDATETOTAL
  2.   AFTER UPDATE OR INSERT ON s_item FOR EACH ROW 
  3. DECLARE
  4. BEGIN
  5.   UPDATE s_ord
  6.   SET total = (SELECT SUM(PRICE * QUANTITY)
  7.               FROM S_ITEM
  8.               WHERE ORD_ID =  :NEW.ord_id)
  9.               GROUP BY ORD_ID;
  10.   WHERE ID = :NEW.ord_id;
  11. END P6_4_UPDATETOTAL;

Report this snippet  

You need to login to post a comment.