用PLSQL做一个函数和一个存储过程。

procedure updatesal_pro(emp_id number,newsal number) --过程 修改工资
IS
BEGIN
update emp set salary=newsal where employee_id=emp_id;
dbms_output.put_line(newsal);
END;

function updatesal_fun(emp_id number)return number is-函数 求年薪
sum_sal number;
BEGIN
select nvl2(commission_pct,(salary+salary*commission_pct)*12,salary*12) into sum_sal from emp where employee_id=emp_id;
return sum_sal;
END;

create or replace function()
declare

begin

end

create or replace procedure()
declare

begin

end