I tried something from ask tom but that only works with sql types.
我使用的是 oracle 11g.有内置的东西吗?
I am using oracle 11g. Is there something built-in?
推荐答案
以下作品调用它作为select * from table(splitter('a,b,c,d'))
The following works
invoke it as
select * from table(splitter('a,b,c,d'))
createorreplacefunction splitter(p_str in varchar2) returnsys.odcivarchar2list
is
v_tab sys.odcivarchar2list:=newsys.odcivarchar2list();
beginwith cte as (selectlevel ind from dual
connectbylevel <=regexp_count(p_str,',') +1
)
select regexp_substr(p_str,'[^,]+',1,ind)
bulkcollectinto v_tab
from cte;
return v_tab;
end;
/
