日期:2014-05-17  浏览次数:20883 次

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, '$ ', ', ');