Oracle's method of converting a particular delimited string into a table (for cursor-like traversal) ____oracle

CREATE OR REPLACE TYPE ty_object as OBJECT (Col_name VARCHAR2);
/
CREATE OR REPLACE TYPE ty_table as TABLE of Ty_object;
/
CREATE OR REPLACE FUNCTION str2table (v_str       in VARCHAR2,
                                     v_delimiter in VARCHAR2)
-- The purpose of this function is to convert a string separated by a particular character into a cursor, as an example of traversing the cursor return
 ty_table as
  v_ty_table ty_table;
BEGIN
  SELECT ty_object (regexp_substr v_str,
                                 ' [^ ' | V_delimiter | | ']+ ',
                                 1, Level
                                 ,
                                 ' i ')
    BULK COLLECT to
    v_ty_table from
    DUAL
  CONNECT by level <=
             Length (v_str)-
             Length (Regexp_replace (v_str, ' | | V_delimiter | | ",") + 1;
  return v_ty_table;
End;
/
--Application Sample
SELECT * from TABLE (str2table (' 1,2,3 ', ', '))
; /