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以便后续操作,但是报“必须说明标识符$”,是怎么回事啊。不知道我这样写对不对。求赐教!
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以便后续操作,但是报“必须说明标识符$”,是怎么回事啊。不知道我这样写对不对。求赐教!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货