For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Can you use WITHIN GROUP in XMLAGG? I'd like to convert the LISTAGG statement below to use XMLAGG.
LISTAGG(purchase_order,',')
WITHIN GROUP (ORDER BY sales_date, customer_name) OVER (PARTITION BY sales_date, customer_name) AS purchaseorders,