Hi folks,
this is my Oracle Version :-(
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
If I have an XML document like
<ROWSET>
<ROW>
<TEXT>abc &lt;def&gt;</TEXT>
</ROW>
</ROWSET>
I can retrieve the text element like
SQL>SELECT XMLType('<ROWSET><ROW><TEXT>abc <def></TEXT></ROW></ROWSET>').extract('/ROWSET/ROW/TEXT/text()').getStringVal() AS x FROM DUAL;
X
--------------------------------------------------
abc &lt;def&gt;
but I need it like
X
--------------------------------------------------
abc <def>
Please help!
Urs