Posted By

wh0emPah on 03/31/10


Tagged


Versions (?)

aaze


 / Published in: PL/SQL
 

  1. CREATE OR REPLACE FUNCTION P1_7_KLEINSTE_VOORRAAD RETURN NUMBER AS
  2. V_PRODUCTID S_PRODUCT.ID%TYPE;
  3.  
  4. SELECT ID
  5. INTO V_PRODUCTID
  6. FROM S_PRODUCT
  7. WHERE TOTAL_IN_STOCK = (SELECT MIN(TOTAL_IN_STOCK) FROM S_product);
  8.  
  9. RETURN V_PRODUCTID;
  10. END P1_7_KLEINSTE_VOORRAAD;

Report this snippet  

You need to login to post a comment.