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, 1773🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...