LISTAGG in PLSQL

Example 1:

SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM order_line_commission_tab t;

Example 2:

SELECT LISTAGG(product_name, '; ') WITHIN GROUP (ORDER BY product_name DESC) "Product_Listing"
FROM   products;

Example 3:

SELECT RTRIM(XMLAGG(XMLELEMENT(e, text, ',').EXTRACT('//text()')).GetClobVal(),',') very_long_text
FROM   (SELECT TO_CHAR(TO_DATE(level, 'j'), 'jsp') text FROM DUAL CONNECT BY LEVEL < 250);

Related Links:

Oracle / PLSQL: LISTAGG Function

sql - Oracle - ORA-01489: result of string concatenation is too long - Stack Overflow