wk8-inclass-mon

gistfile1.txt

CREATE OR REPLACE FUNCTION getPrice (Product_ID IN VARCHAR2) 
RETURN NUMBER
    IS price NUMBER(7,2);
    CURSOR cur_products IS SELECT PRODUCT_PRICE INTO price FROM product WHERE PRODUCT_ID=Product_ID;

BEGIN
    open cur_products;
    FETCH cur_products INTO price;
    return price;
END;

SET SERVEROUTPUT ON;
 BEGIN
    dbms_output.put_line(getPrice(100)); 
 END;