Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

mqiojfei


 / Published in: PL/SQL
 

  1. TRIGGER P6_7_TRIGGER1 BEFORE
  2. INSERT OR UPDATE OF ord_id ON s_item
  3. SELECT ord_id, COUNT(*) QUANTITY BULK COLLECT INTO P5_summit_pkg.t_totord
  4. FROM s_item
  5. GROUP BY ORD_ID;
  6. END P6_7_TRIGGER1 ;

Report this snippet  

You need to login to post a comment.