Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Loading XML data into database — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Loading XML data into database

Accepted answer
edited Aug 7, 2020 2:36PM in Autonomous Database 4 comments


How to load a CSV file into database that contains a field with XML data



I'm hoping you can help. I have a CSV file containing textual and XML data, as the example below demonstrates. I need to load this into a table in my database. A copy of the file is also attached.

292+|Next-Door Bike Store+|279+| <StoreSurvey xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"><AnnualSales>800000</AnnualSales><AnnualRevenue>80000</AnnualRevenue><BankName>United Security</BankName><BusinessType>BM</BusinessType><YearOpened>1996</YearOpened><Specialty>Mountain</Specialty><SquareFeet>21000</SquareFeet><Brands>2</Brands><Internet>ISDN</Internet><NumberEmployees>13</NumberEmployees></StoreSurvey>+|A22517E3-848D-4EBE-B9D9-7437F3432304+|2014-09-12 11:15:07.497000000&|
294+|Professional Sales and Service+|276+| <StoreSurvey xmlns="

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!