xml

Поиск
Список
Период
Сортировка
Искать

xml

От:
Ramesh T <rameshparnanditech@gmail.com>
Дата:
Вложения:
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.


FAQ