My Oracle Support Banner

Is it possible to suppress the CDATA string in XML output? (Doc ID 1288726.1)

Last updated on NOVEMBER 25, 2019

Applies to:

Oracle SQL Developer - Version 1.5 to 3.0 [Release 1.5.0 to 3]
Information in this document applies to any platform.

Goal

Is it possible to alter, or suppress altogether, the CDATA strings in XML query output in SQL Developer?
For example, if you unload the data from a demo table to an XML file, you can see the CDATA strings included in the output.

Sample demo Export in XML Format
<ROW> 
<COLUMN NAME="COLUMNID"><![CDATA[10]]></COLUMN> 
<COLUMN NAME="COLUMNNAME"><![CDATA[ACCOUNTING]]></COLUMN> 
<COLUMN NAME="CLUMNLOCATION"><![CDATA[NEW YORK]]></COLUMN> 
</ROW>

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.