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
ihave is the following:
SELECT xmlelement(name words,
xmlforest(nachname))
FROM person
SELECT xmlelement(name words,xmlforest(nachname))FROM personbut 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
inadvance!bye, flo Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief!
JetztDe-Mail-Adresse reservieren: https://produkte.web.de/go/demail02