Collections:
Export Data to an XML File in Oracle
How To Export Data to an XML File in Oracle?
✍: FYIcenter.com
If you want to export data from a table to a file in XML format, you can use the following steps:
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>
⇒ Create a Stored Procedure Interactively in Oracle
⇐ Export Data to a CSV File in Oracle
2019-01-12, 3820🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both b...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...