xml

[Ramesh T <rameshparnanditech@xxxxxxxxx>]

Hi all,

             SELECT  xmlagg(xmlelement(

                          name actor, xmlattributes(first_name)

                        )ORDER BY actor_id,',')from actor;

the above code return following result,

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.