Converting SQL output Rows in to single row output separated by comma in Oracle

Select Listagg(columnname)  within group (order by 1)  as Col1
from TableName

 

Use the PL/SQL Code to show multiple row output in one row separated by comma.

Converting SQL output Rows in to single row output separated by comma in Oracle was last modified: January 10th, 2018 by Justin Antony

About Justin Antony

https://forum.sqlpublic.com

Leave a Reply