SQL> select listagg (b) 2 within group (order by null) ||' Batman' 3 from (select 0f/0 b 4 from dual 5 connect by level <= 14 6 ); LISTAGG(B)WITHINGROUP(ORDERBYNULL)||'BATMAN' -------------------------------------------------------------------------------- NanNanNanNanNanNanNanNanNanNanNanNanNanNan Batman
Of course you know, you don't need that inline select :-)
ReplyDeletebut it makes it so much easier to understand :)
Delete