日期:2014-05-17 浏览次数:21043 次
declare
l_name varchar2(20);
function p_get_ename(v_empno number)
return varchar2
is
v_enmae varchar2(20);
begin
select ename into v_ename from emp;
return v_ename;
end;
begin
l_name := p_get_ename(7639);
dbms_output.put_line(l_name);
end;