CREATEORREPLACEprocedure test asbegin dbms_output.put_line('HelloWorld');
end;
带参数的存储过程
给指定的员工涨100元工资,并且打印涨前和涨后的薪水:
1
2
3
4
5
6
7
8
9
10
11
createorreplaceprocedure test(pempno in emp.empno%type)
as pename emp.ename%type;
beforesal emp.sal%type;
aftersal emp.sal%type;
beginselect ename,sal into pename,beforesal from emp where empno=pempno;
aftersal:=beforesal+100;
update emp set sal=aftersal where empno=pempno;
dbms_output.put_line('姓名: '||pename||' 涨前工资:'||beforesal||'涨后工资:'||aftersal);
end;