读书人

oracle函数有关问题!

发布时间: 2012-01-31 21:28:41 作者: rapoo

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

读书人网 >oracle

热点推荐