Oracle 11g Release 2

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

create type tbl_t as table of varchar(100);
create table foo(bar varchar(100));
insert into foo(bar) values('A');
1 rows affected

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

with w as (select 1 baz, cast(collect(bar) as tbl_t) qux from foo)
select * from w
union all
select baz,null from w;
with w as (select 1 baz, dump(collect(bar),16) from foo)
select * from w
union all
select * from w;


BAZ
DUMP(COLLECT(BAR),16)


1
Typ=58 Len=19: c0,29,27,a,0,0,0,0,f8,b1,cc,e2,5c,7f,0,0,80,51,d2

1
Typ=58 Len=19: c0,29,27,a,0,0,0,0,f8,b1,cc,e2,5c,7f,0,0,80,51,d2

BAZ	DUMP(COLLECT(BAR),16)
1	Typ=58 Len=19: c0,29,27,a,0,0,0,0,f8,b1,cc,e2,5c,7f,0,0,80,51,d2
1	Typ=58 Len=19: c0,29,27,a,0,0,0,0,f8,b1,cc,e2,5c,7f,0,0,80,51,d2