How To Export Data to an XML File
Q
How To Export Data to an XML File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: FYIcenter.com
A
If you want to export data from a table to a file in XML format, you can use the following steps:
- Right-click the table name, EMPLOYEES, in the object tree view.
- Select Export.
- Select XML. The Export Data window shows up.
- Click Format tab.
- Select Format as: XML.
- Enter File as: \temp\MyTeam.xml.
- Click Columns tab.
- Check columns: FIRST_NAME, LAST_NAME, MANAGER_ID
- Click Where tab.
- Enter Where clause as: MANAGER_ID=100.
- Click Apply.
Your XML file, \temp\MyTeam.xml, is ready. Open it, you will see:
<?xml version='1.0' encoding='Cp1252' ?>
<results>
<row>
<FIRST_NAME><![CDATA[Gerald]]></FIRST_NAME>
<LAST_NAME><![CDATA[Cambrault]]></LAST_NAME>
<MANAGER_ID><![CDATA[100]]></MANAGER_ID>
</row>
<row>
<FIRST_NAME><![CDATA[Lex]]></FIRST_NAME>
<LAST_NAME><![CDATA[De Haan]]></LAST_NAME>
<MANAGER_ID><![CDATA[100]]></MANAGER_ID>
</row>
</results>
2007-04-27, 7864👍, 0💬
Related Topics: