select column1 into number from tablename where c_olumn2="....."; 错误提示我缺少表达式
create or replace function tablename(chr varchar2) return varchar2 is num number; begin select 1 into num from v1 where v=chr and rownum < 2; if num > 0 then return '-20001,已经存在'; end if; end ; /
create or replace function test(chr varchar2) return varchar2 is num number; begin select 1 into num from tablename where column2=chr and rownum < 2; if num > 0 then return '-20001,已经存在'; end if; end ; /select test(变量) from dual;
错误提示我缺少表达式
is
num number;
begin
select 1 into num from v1 where v=chr and rownum < 2;
if num > 0 then
return '-20001,已经存在';
end if;
end ;
/
is
num number;
begin
select 1 into num from tablename where column2=chr and rownum < 2;
if num > 0 then
return '-20001,已经存在';
end if;
end ;
/select test(变量) from dual;