CREATE OR REPLACE 
TYPE string_table                                                                           
	as table of varchar2(4000)
/

CREATE OR REPLACE 
FUNCTION split_string (
	string IN varchar2,
    delimiter IN varchar2
) RETURN  string_table IS
	tab string_table;
	pre integer;
	post integer;
	step integer;
	i integer;
BEGIN
	pre := 1;
	step := length(delimiter);
	i := 0;
	tab := string_table();
	if string is null then 
		return tab;
	end if;
	loop
		i := i + 1;
		post := instr(string,delimiter,pre);
		tab.extend;
		if ( post = 0 ) then
			tab(i) := substr(string,pre);
			return tab;
		end if;
		tab(i) := substr(string,pre,post-pre);
		pre := post + step;
	end loop;
END;
/

SQL> select idx,collect(column_value order by rid) as your_array
  2  from (
  3             select rid,column_value,
  4                     row_number() over (partition by rid order by null) as idx
  5             from (
  6                             select a.rid,b.column_value
  7                             from (
  8                                             select rownum rid,column_value
  9                                             from table(string_table('1,2,3','11,34,22','2,3,4'))
 10                                     ) a cross join table (split_string(a.column_value,',')) b
 11                     )
 12     )
 13  group by idx
 14  /

       IDX  YOUR_ARRAY
----------  -----------------------------------------------
         1  SYSTPV8eCiX7AHKXgRAAXpFGBgA==('1', '11', '2')
         2  SYSTPV8eCiX7AHKXgRAAXpFGBgA==('2', '34', '3')
         3  SYSTPV8eCiX7AHKXgRAAXpFGBgA==('3', '22', '4')