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, 1752🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...