看着真别扭。是Oracle不是orcale
create or replace function func_math_oper(str in varchar2)
return number
as
v_result number;
begin
execute immediate 'select '||str||' from dual' into v_result;
return v_result;
exception
when others then
return -1;
end;
/
create or replace function func_math_oper(str in varchar2)
return number
as
v_result number;
begin
execute immediate 'select '||str||' from dual' into v_result;
return v_result;
exception
when others then
return -1;
end;
/
l_result number;
l_sql varchar2(1000);
begin
l_sql:='select '||num1||||num2||' from dual';
execute immediate l_sql into l_result;
return(l_result);
exception when others then
return 0;
end test;--测试
select test(12,'*',23) from dual;