Hi forum,
On Oracle 11g ...
I have a sql-statement like this:
select xx.*
from stepxml,xmltable('/ROWSET/ZEILE' passing stepxml.x columns
a varchar2(100) path 'A'
, b varchar2(100) path 'B'
) xx
;
With XMLTABLE() I have to give a specification for every column that I want to query. This can become quite cumbersome if the XML has got a lot of tags.
I wonder, if there is a way to omit the columns alltogether and still get a table-like output holding every tag present in the xml? Any ideas?
Thanks,
Stephan