Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create or replace type stringTable is table of varchar2 (32)
/
create or replace function getColumn (
    schema varchar2, tabname varchar2, colname varchar2
        ) return stringtable as
    ret stringtable;
begin
    execute immediate '
        select '||colname||' 
        from '  ||schema ||'.'||tabname bulk collect into ret;
    return ret;
end;
/
create table t (id, memo, created) as
    select rownum, 'row '||rownum, date'2021-08-01'+(rownum) 
    from dual connect by level<=3
/
3 rows affected

select * from table (getColumn (user, 't', 'id'))


COLUMN_VALUE


1

2

3


select * from table (getColumn (user, 't', 'memo'))


COLUMN_VALUE


row 1

row 2

row 3


select * from table (getColumn (user, 't', 'created'))


COLUMN_VALUE


02-AUG-21

03-AUG-21

04-AUG-21