Posted By

wh0emPah on 04/01/10


Tagged


Versions (?)

azeae


 / Published in: PL/SQL
 

  1. CREATE OR REPLACE PROCEDURE P3_3_NOOIT_BESTELD AS
  2. CURSOR C_NBESTELD IS
  3. SELECT ID, NAME, SHORT_DESC
  4. FROM S_PRODUCT
  5. FROM S_ITEM
  6. WHERE PRODUCT_ID = ID);
  7. FOR R_NBESTELD IN C_NBESTELD LOOP
  8. DBMS_OUTPUT.PUT_LINE(R_NBESTELD.ID || ' ' || R_NBESTELD.NAME || ' ' || R_NBESTELD.SHORT_DESC);
  9. UPDATE s_product
  10. SET SUGGESTED_WHLSL_PRICE = SUGGESTED_WHLSL_PRICE * 0.9
  11. WHERE ID = R_NBESTELD.ID;
  12. END P3_3_NOOIT_BESTELD;

Report this snippet  

You need to login to post a comment.