• 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:53am

 / Published in: PL/SQL

 

CREATE OR REPLACE
TRIGGER P6_7_TRIGGER1 BEFORE
  INSERT OR UPDATE OF ord_id ON s_item 
  BEGIN
  SELECT ord_id, COUNT(*) QUANTITY BULK COLLECT INTO P5_summit_pkg.t_totord
  FROM s_item
  GROUP BY ORD_ID;
END P6_7_TRIGGER1 ;

Report this snippet   Tweet