advanced code snippet search

Posted By

wh0emPah on 03/31/10


Tagged


Versions (?)

aaze

 / Published in: PL/SQL
 
Expand | Embed | Plain Text 
  1. CREATE OR REPLACE FUNCTION P1_7_KLEINSTE_VOORRAAD RETURN NUMBER AS 
  2.   V_PRODUCTID S_PRODUCT.ID%TYPE;
  3. BEGIN
  4.  
  5.   SELECT ID
  6.   INTO V_PRODUCTID
  7.   FROM S_PRODUCT
  8.   WHERE TOTAL_IN_STOCK = (SELECT MIN(TOTAL_IN_STOCK) FROM S_product);
  9.  
  10.   RETURN V_PRODUCTID;
  11. END P1_7_KLEINSTE_VOORRAAD;

Report this snippet  

You need to login to post a comment.