Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TYPE string_list AS TABLE OF VARCHAR2(15);
CREATE FUNCTION my_oracle_table_fn(
  i_list IN string_list
) RETURN string_list
IS
BEGIN
  RETURN i_list;
END;
/
SELECT column_value
FROM   TABLE(
         my_oracle_table_fn(
           (
             SELECT CAST(
                      COLLECT(
                        CAST(dbms_random.string('U',15) AS VARCHAR2(15))
                      )
                      AS string_list
                    )
             FROM   DUAL
             CONNECT BY LEVEL <= 10
           )
         )
       );


COLUMN_VALUE


ACEORDSCQUIKGMA

QDABCJUURDCGWEE

POVKRPPUDAHTIMY

LFNEUXVVBVDFLKW

HIRLFZAVHEQLTKO

HGAEHXERAFLSBWB

LXDVMNTJIGPWYYF

LDBBALCPCWNTJMC

AMTKZCYMTXOWXDF

CPVCHLEDMDIKWEZ