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.
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.
<ROW> <COLUMN NAME="COLUMNID"><![CDATA]></COLUMN> <COLUMN NAME="COLUMNNAME"><![CDATA[ACCOUNTING]]></COLUMN> <COLUMN NAME="CLUMNLOCATION"><![CDATA[NEW YORK]]></COLUMN> </ROW>
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!