Splitting strings

The APEX_STRING.SPLIT function is a great utility function that allows you to split a string into its component parts based on a delimiter

The function returns a result in a collection of type apex_t_varchar2

Here is a sample code block

declare
  l_result apex_t_varchar2;
begin
  l_result:=apex_string.split(p_str => 'a'||chr(9)||'b'||chr(9)||'c',
                              p_sep => chr(9));

  for i in 1..l_result.count
  loop
    dbms_output.put_line(l_result(i));
  end loop;
end;