Monday, May 21, 2012

Oracle 11g: XQuery results concatenated in a single SQLXML type

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?



Thanks,



Eric





No comments:

Post a Comment