創建一個函數 輸入姓名 返回年薪（表里存的是月薪）
create function sp_fun2(spName varchar2) return number is yearSal number(10,2);beginselect sal*12 into yearSal from emp where name=spName;return yearSal;end;/調用函數var a number; 定義一個變量call sp_fun2('xiaom') into:a; 輸入姓名 把返回值放入變量a里面；創建包sp_package 聲明包里面有個過程update_sal 聲明包里面有個函數annual_income
create package sp_package isPRocedure update_sal(spName varchar2,newSal number);function annual_income(spName varchar2) return number;end;/給包sp_package 實現包體
create package body sp_package isprocedure update_sal(spName varchar2,newSal number)isbeginupdate emp set sal=newSal where name=spName;end;function annual_income(spName varchar2)return number isannual_salary number;beginselect sal into annual_salary from empwhere name=spName;return annual_salary;end;end;/調用包exec sp_package.update_sal('xiaom',899);新聞熱點
疑難解答
