create or replace type shuzu as table of number;
create or replace function haluo(fenge in varchar2)
return shuzu
as
zifu1 varchar2(1000) default fenge||',';
zifu2 varchar2(1000);
leixing shuzu:=shuzu();
begin
loop
zifu2:=instr(zifu1,',');
exit when (nvl(zifu2,0)=0);
leixing.extend;
leixing(leixing.count):=ltrim(rtrim(substr(zifu1,1,zifu2-1)));
zifu1:=substr(zifu1,zifu2+1);
end loop;
return leixing;
end;
这个函数我自己测试了一下 只能分割数字,如果我想不管是数字中文还是字母都能分割,可以改哪里?
------解决方案--------------------
你把那个入参改成NVARCHAR2(60)试试
------解决方案--------------------
create or replace type shuzu as table of number -->create or replace type shuzu as table of varchar2;