PL/SQL column concatenation

select wm_concat(name),
LISTAGG(recipient_type, ‘,’) WITHIN GROUP (ORDER BY recipient_type) text
from (
select ‘test1’ as name from dual
union
select ‘test2’ as name from dual
)

https://oracle-base.com/articles/misc/string-aggregation-techniques

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s