Hi,
Oracle 10.2.0.4
When I do this:
select xmlelement("MyTag")
from dual;
It results in: <MyTag></MyTag>
When I do this:
select xmlelement("MyTag").extract('/*')
from dual;
It results in: <MyTag/>
My requirement is to get the latter result.
However the second query (with the .extract('/*')), is 4 times as expensive, cpu-wise.
Doing this:
select XMLType('<MyTag/>')
from dual;
Is even worse yet. So also not an option.
Any other ideas?
Edited by: Toon Koppelaars on Jan 13, 2010 1:50 PM
Added Oracle version.