hi there!

i wanted to ask how to get an xml output from a table like this:

<words>
<first_name>joe</first_name>
<first_name>ian</first_name>
<first_name>carl</first_name>
<first_name>ben</first_name>
</words>

what i have is the following:

SELECT xmlelement(name words,
xmlforest(nachname))
FROM person
SELECT
xmlelement(name words,
xmlforest(nachname))
FROM person

but that gives me this:

<words><first_name>joe</first_name></words>
<words><first_name>ian</first_name></words>
<words><first_name>carl</first_name></words>
<words><first_name>ben</first_name></words>


thanks in advance!

bye, flo


 
  

Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief!    
Jetzt De-Mail-Adresse reservieren: https://produkte.web.de/go/demail02