Oracle SQL Developer by Ajith Narayanan

Author:Ajith Narayanan [Narayanan, Ajith]
Language: eng
Format: azw3, mobi, epub, pdf
Publisher: Packt Publishing
Published: 2016-01-29T16:00:00+00:00

Exporting to XML

The SQL Developer Data Export also supports exporting to XML. To create an XML file, based on the data in the grid, go to Export Data | xml using the context menu. A single row of data (in this case from the EMPLOYEES table) exported to XML follows a structured format as follows:

<ROW> <COLUMN NAME="EMPLOYEE_ID"><![CDATA[100]]></COLUMN> <COLUMN NAME="FIRST_NAME"><![CDATA[Steven]]></COLUMN> <COLUMN NAME="LAST_NAME"><![CDATA[King]]></COLUMN> <COLUMN NAME="EMAIL"><![CDATA[SKING]]></COLUMN> <COLUMN NAME="PHONE_NUMBER"><![CDATA[515.123.4567]]></COLUMN> <COLUMN NAME="HIRE_DATE"><![CDATA[17-JUN-87]]></COLUMN> <COLUMN NAME="JOB_ID"><![CDATA[AD_PRES]]></COLUMN> <COLUMN NAME="SALARY"><![CDATA[24000]]></COLUMN> <COLUMN NAME="COMMISSION_PCT"><![CDATA[]]></COLUMN> <COLUMN NAME="MANAGER_ID"><![CDATA[]]></COLUMN> <COLUMN NAME="DEPARTMENT_ID"><![CDATA[90]]></COLUMN> </ROW>

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.