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
4
Views
4
Comments
edited Aug 7, 2020 2:36PM in Autonomous Database 4 comments

Summary

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

Content

Hi,

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.

Register

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