create or replace function select_name(v_id number)
return varchar2
is
v_name varchar2(20)
begin
select name into v_name
from teacher where id=v_id;
return (v_name);
end;
警告: 创建的函数带有编译错误。
=----------------------
我的函数写的有问题么 怎么都看不出来啊
return varchar2
is
v_name varchar2(20)
begin
select name into v_name
from teacher where id=v_id;
return (v_name);
end;
警告: 创建的函数带有编译错误。
=----------------------
我的函数写的有问题么 怎么都看不出来啊
create or replace function select_name(v_id number)
return varchar2
is
v_name varchar2(20);
begin
select name into v_name
from teacher where id=v_id;
return (v_name);
end;
show error即会将错误print出来
return varchar2
is
v_name varchar2(20);
begin
select name into v_name from teacher where id=v_id;
return (v_name);
end;--v_name varchar2(20); 变量申明少个分号