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, 2354🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...