Read XML file and stored in SQL db

Hi,

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 ?
https://livesql.oracle.com/apex/livesql/file/tutorial_HE5NRRMNBOHLLKRLZJU0VNRCB.html

1.Fetched data from Oracle db to SQL db

  1. Then XML data stored in SQL db

Hi,

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