When I run an XQuery query in PL-SQL using
SELECT XQUERY('...' RETURNING CONTENT) FROM DUAL
the result is always returned concatenated in a single row single column holding a SQLXML field.
This is bad for queries returning sequences of elements and really nasty for queries returning sequences of text nodes.
Is there a way to avoid this concatenation and get a row per returned item?