oracle中创建函数

1.简单函数

create or replace function get_sal(name1 varchar2)
return number is
v_sal number(6,2);
begin
select sal into v_sal from emp where upper(ename)=upper(name1);
return v_sal;
end;

var salary number;
exec :salary:=get_sal('scott');
exec :salary:=get_sal('smith');