Oracle plsql Demo-24. Delimited String function

--Refer:--http://www.cnblogs.com/gnielee/archive/2009/09/09/1563154.html--http://www.cnblogs.com/yudy/archive/2012/07/18/2597874.htmlCREATE OR REPLACETYPE Ty_str_split is TABLE  of VARCHAR2(4000);CREATE OR REPLACE FUNCTIONSplitstr (p_stringinch VARCHAR2, P_delimiterinch VARCHAR2:= ',')    RETURNty_str_split pipelined asV_length Number:=LENGTH (p_string); V_start Number:= 1; V_index Number; V_length_delimiter Number:=LENGTH (p_delimiter);BEGIN     while(V_start<=v_length) LOOP V_index:=INSTR (p_string, P_delimiter, V_start); IFV_index= 0  Then            PIPEROW (SUBSTR (p_string, V_start)); V_start:=V_length+ 1; ELSE            PIPEROW (SUBSTR (p_string, V_start, V_index-V_start)); V_start:=V_index+V_length_delimiter; END IF; ENDLOOP; RETURN;ENDSPLITSTR;

Oracle plsql Demo-24. Delimited String function