Oracle单个字符串拆分函数

CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000)

create or replace function fn_gzk_zfjq(p_value varchar2)
 return ty_str_split
  pipelined is
  v_str       varchar2(2000);

begin
  --字符串截取为字符
 for i in 1..length(p_value) loop
    v_str:=substr(p_value,i,1);
    pipe row(v_str);
  end loop;
  return;

end fn_gzk_zfjq;

使用：

select x.* from table(fn_gzk_zfjq('asdadasdasd')) x;

select t1.ljjf,t1.qfrq,to_char(wm_concat(d1.dmsm2)) zt,t1.yxqs,t1.yxqz,t1.dabh from (
select t.ljjf,
       t.qfrq,
       t.YXQS,  
       t.YXQZ,
       t.DABH,t.zt,m.* from gzk_jj_jszxx t,table(fn_gzk_zfjq(zt)) m
where t.sfzmhm='340222199004181637') t1
join DICT_JJ_MINGXI d1 on t1.column_value=d1.dmsm1 and d1.dmz='2005' and d1.dmlb='00'
group by t1.ljjf,t1.qfrq,t1.yxqs,t1.yxqz,t1.dabh