01-Procedure.txt

create or replace procedure PRODUCT_UPDATE_SALESPRICE(P_CATEGORYID number,P_PERCENT number)
is
begin

    update PRODUCT
      set SALESPRICE=SALESPRICE+ SALESPRICE*P_PERCENT/100
      where CATEGORYID=P_CATEGORYID;


end;​


begin

   PRODUCT_UPDATE_SALESPRICE(2,10);

end;
/