clear markdown 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. 363531 distinct fiddles created so far.

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
1 rows affected
 hidden batch(es)


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


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;
BAZ QUX
BAZ QUX
 hidden batch(es)


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
 hidden batch(es)