Oracle: DBMS_UTILITY - COMMA_TO_TABLE / TABLE_TO_COMMA

set serveroutput on
declare
   arr       dbms_utility.uncl_array;
   cnt       binary_integer;
begin
   dbms_utility.comma_to_table('foo,bar,baz', cnt, arr);
   for i in 1 .. cnt loop
      dbms_output.put_line(arr(i));
   end loop;
end;
/

declare
   arr       dbms_utility.uncl_array;
   txt       varchar2(4000);
   cnt       binary_integer;
begin
   arr(1) := 'Foo';
   arr(2) := 'Bar';
   arr(3) := 'Baz';
   
   dbms_utility.table_to_comma(arr, cnt, txt);

   dbms_output.put_line(txt);
end;
/