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 |