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.
