oracle函数问题!!
create or replace function FUN_GET(V_IN_ORGID IN NUMBER)
return number is
Result number;
list number;
begin
list:=replace(V_IN_ORGID, "$ ", ", ");
具体操作略
return(Result);
end FUN_GET;
-------
说明:程序给V_IN_ORGID传的值是4683$968$969,想用replace方法替换成4683,968,969以便后续操作,但是报“必须说明标识符$”,是怎么回事啊。不知道我这样写对不对。求赐教!
------解决方案--------------------list:=replace(V_IN_ORGID, "$ ", ", ");
换成
list:=replace(V_IN_ORGID, '$ ', ', ');
或者
list:=translate(V_IN_ORGID, '$ ', ', ');