12 PL/SQL函数

create or replace function my_fun(v_name varchar2)
return number is
v_annual_sal number;
begin
  select sal*13 into v_annual_sal from test where name=v_name;
  return v_annual_sal;
end;

select my_fun('Allen') from test;