存儲過程:
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsICdzFWRoRXdvN1LclHdpZXYyd2LcBzNvwVZ2x2bzNXak9CX90TQNNkRrFlQKBTSvwFbslmZvwFMwQzLcVmepNHdu9mZvwFVywUNMZTY18CX052bm9CXwZ0MaVHbXJmb1IjYvx2VZZXUYpVd1kmYr50MZV3YyI2cKJDT29GRjBjUIF2LcRHelR3LcJzLctmch1mclRXY39TOyczMzQjMzIDOwATM0EDMy8CX0Vmbu4GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.jpg)
更多Oracle資料、視訊教程:
http://2.taobao.com/item.htm?id=42922011874&spm=686.1000925.0.0.ZVvkz6&mt=
如何在Java中調用存儲過程:
函數:
更多Oracle資料、視訊教程:
http://2.taobao.com/item.htm?id=42922011874&spm=686.1000925.0.0.ZVvkz6&mt=
執行個體:
輸入雇員的姓名,傳回該雇員的年薪
create function sp_fun2(spName varchar2) return
number is yearSal number(7,2);
--執行部分
select sal*12+nvl(comm,0)*12 into yearSal from emp where ename=spName;
return yearSal;
end;
如何調用函數:
var abc number;
call sp_fun2('SCOTT') into:abc;
包: