oracle创建函数

create or replace function get_sal(name in varchar2)
return number as
v_sal scott.emp.sal%TYPE;
Begin
SELECT sal into v_sal from scott.emp
where upper(ename)=upper(name);
return v_sal;
Exception
when no_data_found then
raise_application_error(-2000,'employee is not exeist');
end;
/


调用函数

var sal number
exec:sal:=get_sal('scott')

显示
print sal

SAL
------
3300