Hi all, SELECT xmlagg(xmlelement( name actor, xmlattributes(first_name) )ORDER BY actor_id,',')from actor;
the above code return following result, [image: Inline image 1] Question : i want retrieve result from above XML result like penelope,nick,jennifer,jhony,,,,, xpath is their but unable to fix this query. any help how to get only names from query not xml.