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, 1878🔥, 0💬
Popular Posts:
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...