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.