Question

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

Answer 1

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;

Answer 2

create or replace function()
declare

begin

end

create or replace procedure()
declare

begin

end

追问

能具体举个实例吗？谢谢！

追答

create or replace procedure aaa() as
declare
var_i number:=10;
begin
for a in 1..var_i loop
dbms_output.put_line('hello world');
end loop;
end