02-Function.txt

create or replace function PRODUCT_SALESPRICE_AVERAGE (P_CATEGORYID number)
return number 
is
    R_SALESPRICEAVERAGE number :=0;
begin

  select avg(SALESPRICE) into R_SALESPRICEAVERAGE from PRODUCT where CATEGORYID=P_CATEGORYID;

  return R_SALESPRICEAVERAGE;

end;
/

declare 

  V_SALESPRICE_AVERAGE number;

begin


  V_SALESPRICE_AVERAGE:=PRODUCT_SALESPRICE_AVERAGE(2);

  dbms_output.put_line(V_SALESPRICE_AVERAGE);

end;