scott@ORA92> -- test data:
scott@ORA92> SELECT * FROM your_table
  2  /

STRING_COL
------------------------------
10.01.03.04.234
234.05.07.032

scott@ORA92> -- function:
scott@ORA92> CREATE OR REPLACE FUNCTION list_element
  2    (p_string    VARCHAR2,
  3  	p_element   INTEGER,
  4  	p_separator VARCHAR2)
  5    RETURN	    VARCHAR2
  6  AS
  7    v_string     VARCHAR2(32767);
  8  BEGIN
  9    v_string := p_string || p_separator;
 10    FOR i IN 1 .. p_element - 1 LOOP
 11  	 v_string := SUBSTR(v_string,INSTR(v_string,p_separator)+1);
 12    END LOOP;
 13    RETURN SUBSTR(v_string,1,INSTR(v_string,p_separator)-1);
 14  END list_element;
 15  /

Function created.

scott@ORA92> -- usage:
scott@ORA92> SET SERVEROUTPUT ON
scott@ORA92> DECLARE
  2    var1 VARCHAR2(5);
  3    var2 VARCHAR2(5);
  4    var3 VARCHAR2(5);
  5    var4 VARCHAR2(5);
  6    var5 VARCHAR2(5);
  7  BEGIN
  8    FOR rec IN (SELECT string_col FROM your_table) LOOP
  9  	 SELECT list_element (rec.string_col, 1, '.'),
 10  		list_element (rec.string_col, 2, '.'),
 11  		list_element (rec.string_col, 3, '.'),
 12  		list_element (rec.string_col, 4, '.'),
 13  		list_element (rec.string_col, 5, '.')
 14  	 INTO	var1, var2, var3, var4, var5
 15  	 FROM	DUAL;
 16  	 DBMS_OUTPUT.PUT_LINE ('string: ' || rec.string_col);
 17  	 DBMS_OUTPUT.PUT_LINE ('var1: ' || var1);
 18  	 DBMS_OUTPUT.PUT_LINE ('var2: ' || var2);
 19  	 DBMS_OUTPUT.PUT_LINE ('var3: ' || var3);
 20  	 DBMS_OUTPUT.PUT_LINE ('var4: ' || var4);
 21  	 DBMS_OUTPUT.PUT_LINE ('var5: ' || var5);
 22  	 DBMS_OUTPUT.PUT_LINE ('-------------------------------');
 23    END LOOP;
 24  END;
 25  /
string: 10.01.03.04.234
var1: 10
var2: 01
var3: 03
var4: 04
var5: 234
-------------------------------
string: 234.05.07.032
var1: 234
var2: 05
var3: 07
var4: 032
var5:
-------------------------------

PL/SQL procedure successfully completed.

scott@ORA92> create or replace type myTableType as table of varchar2(255);
  2  /

Type created.

scott@ORA92> create or replace function str2tbl
  2  	 (p_str   in varchar2,
  3  	  p_delim in varchar2 default '.')
  4  	 return      myTableType
  5  as
  6  	 l_str	    long default p_str || p_delim;
  7  	 l_n	    number;
  8  	 l_data     myTableType := myTabletype();
  9  begin
 10  	 loop
 11  	     l_n := instr( l_str, p_delim );
 12  	     exit when (nvl(l_n,0) = 0);
 13  	     l_data.extend;
 14  	     l_data( l_data.count ) := ltrim(rtrim(substr(l_str,1,l_n-1)));
 15  	     l_str := substr( l_str, l_n+length(p_delim) );
 16  	 end loop;
 17  	 return l_data;
 18  end;
 19  /

Function created.

scott@ORA92> SELECT *
  2  FROM   TABLE (CAST (str2tbl ('10.01.03.04.234') AS mytabletype))
  3  /

COLUMN_VALUE
----------------------------------------------------------------------------------------------------
10
01
03
04
234

scott@ORA92> DECLARE
  2    v_array mytabletype;
  3  BEGIN
  4    v_array := str2tbl ('10.01.03.04.234');
  5    FOR i IN 1 .. v_array.COUNT LOOP
  6  	 DBMS_OUTPUT.PUT_LINE (v_array(i));
  7    END LOOP;
  8  END;
  9  /
10
01
03
04
234

PL/SQL procedure successfully completed.

SELECT EXTRACTVALUE(xt.column_value,'e')
FROM   TABLE(XMLSEQUENCE
           ( EXTRACT
             ( XMLTYPE('<coll><e>' ||
                       REPLACE('10.01.03.04.234','.','</e><e>') ||
                       '</e></coll>')
             , '/coll/e') )) xt;

DECLARE
    v_csvlist VARCHAR2(100) := '10.01.03.04.234';
    v_xmllist XMLTYPE :=
        XMLTYPE('<coll><e>' || REPLACE(v_csvlist,'.','</e><e>') || '</e></coll>');
BEGIN
    FOR r IN (
        SELECT EXTRACTVALUE(xt.column_value,'e') AS element
        FROM   TABLE(XMLSEQUENCE(EXTRACT(v_xmllist,'/coll/e'))) xt
    )
    LOOP
        DBMS_OUTPUT.PUT_LINE(r.element);
    END LOOP;
END;

SQL> declare
  2  
  3  myString Varchar2(2000):='a:sd:dfg:31456:dasd: :sdfsdf';
  4  
  5  Type v_type is Table of Varchar2(300) index by Binary_Integer;
  6  
  7  v v_type;
  8  
  9  
 10  Begin 
 11  
 12  v:=GetStrings(myString,':');
 13  
 14  End;
 15  
 16  /*-----------------------------------------------------------<---------*/
 17  
 18  Function GetStrings
 19  (p_items Varchar2,
 20  p_delimiter Varchar2)
 21  Return v_type
 22  
 23  
 24  is
 25  
 26  v_varTab_i v_type;
 27  tempString Varchar2(16000);
 28  i Binary_Integer:=1;
 29  i_s number;
 30  i_e number;
 31  i_sp number;
 32  i_ep number:=1;
 33  t_items Varchar2(16000);
 34  
 35  
 36  
 37  Begin
 38  
 39  t_items:=rtrim(p_items,p_delimiter);
 40  t_items:=t_items||p_delimiter;
 41  i_s :=1;
 42  tempString:=substr(t_items,i_s);
 43  i:=1;
 44  
 45  while i_ep > 0
 46  Loop
 47  
 48  i_ep:=instr(tempString,p_delimiter,i_s);
 49  
 50  
 51  if i_ep >0 then
 52  if i_ep-i_s = 0 then v_varTab_i(i):= NULL;
 53  else
 54  v_varTab_i(i):=substr(tempString,i_s,i_ep-i_s);
 55  end if;
 56  i:=i+1;
 57  tempString:=substr(tempString,i_ep+length(p_delimiter));
 58  end if;
 59  
 60  End Loop;
 61  
 62  Return v_varTab_i;
 63  
 64  Exception
 65  when others then
 66  NULL;
 67  
 68  End GetStrings; 
 69  /
Function GetStrings
*
ERROR at line 18:
ORA-06550: line 18, column 1:
PLS-00103: Encountered the symbol "FUNCTION"
ORA-06550: line 19, column 10:
PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent (**)> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIK
ORA-06550: line 26, column 1:
PLS-00103: Encountered the symbol "V_VARTAB_I" when expecting one of the following:
language
ORA-06550: line 68, column 15:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
end not pragma final instantiable order overriding static
member constructor map

create type ty_str_split as table of varchar2(100)
/

create or replace function str_split_as_table (p_str   in varchar2
                                              ,p_delim in varchar2 default ',') 
return ty_str_split pipelined as

  v_tab    ty_str_split;
begin
  v_tab := str_split(p_str,p_delim);
  
  for i in 1..v_tab.last loop
    pipe row(v_tab(i));
  end loop;
  return;
end;;
/

create or replace function str_split  (p_str   in varchar2
                                     ,p_delim in varchar2 default ',') 
return ty_str_split as
  v_str      varchar2(32767);
  v_fields   pls_integer;
  v_substr   varchar2(32767);
  v_return   ty_str_split := ty_str_split();
begin
  v_str := p_delim||trim(p_delim from p_str)||p_delim;
  v_fields := length(v_str) - length(replace(v_str,p_delim,'')) - 1;
  v_return.extend(v_fields);
  
  for i in 1..v_fields loop
    v_substr := substr(v_str
                      ,instr(v_str,p_delim,1,i)+1  
                      ,instr(v_str,p_delim,1,i+1) - instr(v_str,p_delim,1,i) -1);
    v_return(i) := v_substr;
  end loop;
  return v_return;
end;;
/        

select *
from   table(str_split_as_table('asd,456,trfgh,4567'));

select str_split('asd,456,trfgh,4567') from dual;

create or replace function str_split  (p_str   in varchar2
                                     ,p_delim in varchar2 default ',') 
return ty_str_split as
  v_str      varchar2(32767);
  v_fields   pls_integer;
  v_substr   varchar2(32767);
  v_return   ty_str_split := ty_str_split();
begin
  v_str := p_delim||trim(p_delim from p_str)||p_delim;
  v_fields := length(v_str) - length(replace(v_str,p_delim,'')) - 1;
  v_return.extend(v_fields);
  
  for i in 1..v_fields loop
    v_substr := substr(v_str
                      ,instr(v_str,p_delim,1,i)+1  
                      ,instr(v_str,p_delim,1,i+1) - instr(v_str,p_delim,1,i) -1);
    v_return(i) := v_substr;
  end loop;
  return v_return;
end;;
/        

create table c_test as
select 
row_id
str_split(comments_long,' ') as testy
from
MY_TABLE

SQL> select 
  2  row_id,
  3  str_split(comments_long,' ') as testy
  4  from
  5  t;
    ROW_ID
----------
TESTY
---------------------------------------------
      1234
TY_STR_SPLIT('This', 'is', 'an', 'example')

create table t (row_id integer, comments varchar2(100));
insert into t values(1234, 'This is an example');
insert into t values(2345, 'And here is another example');
commit;

SQL> select * from t;
    ROW_ID COMMENTS
---------- ----------------------------------
      1234 This is an example
      2345 And here is another example

2 rows selected.

SQL> col comm format a20
SQL> with
  2    lines as (select level line from dual connect by level <= 10),
  3    data as (select row_id, ' '||trim(comments)||' ' comments from t)
  4  select row_id, line,
  5         substr(comments,
  6                instr(comments,' ',1,line)+1,
  7                instr(comments,' ',1,line+1)-instr(comments,' ',1,line)-1
  8               ) comm
  9  from data, lines
 10  where line < length(comments)-length(replace(comments,' ',''))
 11  order by 1, 2
 12  /
    ROW_ID       LINE COMM
---------- ---------- --------------------
      1234          1 This
      1234          2 is
      1234          3 an
      1234          4 example
      2345          1 And
      2345          2 here
      2345          3 is
      2345          4 another
      2345          5 example

9 rows selected.