Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove CDATA from XML export

251461Mar 15 2006 — edited Apr 6 2011
Hi,

I love the XML export feature, however I would like to remove all the CDATA tags.

The current export looks like this:

<SUB_SYSTEM><![CDATA[FORECAST]]></SUB_SYSTEM>
<PRMTR><![CDATA[CutoffTime]]></PRMTR>
<VALUE><![CDATA[0]]></VALUE>
<UPDATE_USER><![CDATA[PTRAN]]></UPDATE_USER>
<UPDATE_TIME><![CDATA[18-FEB-06]]></UPDATE_TIME>

I would like to export like this:

<SUB_SYSTEM>FORECAST</SUB_SYSTEM>
<PRMTR>CutoffTime</PRMTR>
<VALUE>0</VALUE>
<UPDATE_USER>PTRAN</UPDATE_USER>
<UPDATE_TIME>18-FEB-06</UPDATE_TIME>

Is this possible?

Thank you!
-Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2011
Added on Mar 15 2006
#sql-developer
19 comments
2,267 views