課程

/數(shù)據(jù)庫(kù)

/Oracle

/Oracle存儲(chǔ)過程和自定義函數(shù)

create?or?replace?function?queryenpincome(eno?in?number)
return?number
as
psal?emp.sal%type;
pcomm?emp.comm%type;
begin
??select?sal,comm?into?psal?pcomm?from?emp?where?empno=eno;
??return?psal*12+nvl(pcomm,0);
end;