17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> create or replace function function1 (
2 v_num in employees.employee_id%type,
3 v_name out number
4 ) return varchar2
5 is
6 v_none number(10,2);
7 begin
8 select first_name into v_name from employees where employee_id=v_num;
9 return v_name;
10 end;
11 /
Function created
create function function1(v_num in table1.num%type)
return varchar2
is
v_name varchar2(16);
begin
select name into v_name from table1 where num=v_num;
return v_name;
end function1;