Read XML file and stored in SQL db


please help how to stored XML file in SQL db I’m unable to stored because of XML tag .

XML file columns not same all time

Please help.

Thanks in advance.

HI ,

The datatype of XML is xmltype , which DB can be used ?

1.Fetched data from Oracle db to SQL db

  1. Then XML data stored in SQL db


You can even story the xml file under nvarchar type in the DB.