create or replace function my_fun(v_name varchar2)
return number isv_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;
本文共 285 字，大约阅读时间需要 1 分钟。
create or replace function my_fun(v_name varchar2)
return number isv_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;
转载于:https://www.cnblogs.com/mycheetah/archive/2012/08/14/2638395.html