clear markdown compare help donate comments/suggestions/bugs a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith?
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0

create type tbl_t as table of varchar(100);
 hidden batch(es)


create table foo(bar varchar(100));
 hidden batch(es)


insert into foo(bar) values('A');
1 rows affected
 hidden batch(es)


insert into foo(bar) values('B');
1 rows affected
 hidden batch(es)


select * from foo;
BAR
A
B
 hidden batch(es)


select cast(collect(to_char(bar)) as tbl_t) from foo;
CAST(COLLECT(TO_CHAR(BAR))ASTBL_T)
 hidden batch(es)


select * from table((select cast(collect(to_char(bar)) as tbl_t) from foo));
COLUMN_VALUE
A
B
 hidden batch(es)