CREATE OR REPLACE FUNCTION splitstr(p_string IN VARCHAR2, p_delimiter IN VARCHAR2,NUM IN INTEGER) RETURN varchar2AS v_length NUMBER := LENGTH(p_string); v_start NUMBER := 1; v_index NUMBER; v_str varchar2(20) :=''; v_num NUMBER :=1;BEGIN WHILE(v_start <= v_length) LOOP v_index := INSTR(p_string, p_delimiter, v_start); IF v_index = 0 THEN if v_num = NUM then v_str:= v_str || (SUBSTR(p_string, v_start)); end if; v_start := v_length + 1; ELSE if v_num = NUM then v_str:= v_str || (SUBSTR(p_string, v_start, v_index - v_start)); end if; v_start := v_index + 1; v_num := v_num + 1; END IF; END LOOP; return v_str; END splitstr;
