ORACLE 函数单引号问题
CREATE OR REPLACE FUNCTION PROVINCE (sname in char)
return Integer
as
code integer:=0 ;
begin
select code into code from geography where province like '%sname%' ;
return code;
Exception
when no_data_found then
return 0;
end;
'%sname%' 这样是错的
该怎样加单引号