Heloo Expert's,
I am a below query ...I used list aggreagate but i am getting o/p as list
with temp table as (
select 'amit@gmail.com' email_address,sysdate order_date from dual
union all
select 'fellow@yahoo.com' email_address, sysdate order_date from dual)
select listagg(email_address, ',') within group (order by order_date desc) from temp_table
o/p
amit@gmail.com,fellow@yahoo.com
expected o/p but i need 'amit@gmail.com','fellow@yahoo.com'
Please advise.