读取xml字符串数据并将其插入oracle数据库
问题描述：
我将XML数据作为字符串从vb.net传递。我想读取此字符串并将数据插入oracle table.provide一个soln
I am passing XML data as string from vb.net.I want read this string and insert data into oracle table.provide a soln
答
试试这个，
try this,
Dim strReader As New StringReader(StrXmlValue)
'StrXmlValue is the xml string
Dim xmlreader As New XmlTextReader(strReader)
Dim xmlDoc As New XmlDocument
xmlDoc.Load(xmlreader)
使用此XmlDocument对象，您可以读取XML数据的节点和属性并将其保存在数据库中。
参考链接。
http://stackoverflow.com/questions/11102544/how-to-return-multiple -results-with-xmltable [ ^ ]
http：//www.sqlfiddle。 com /＃！4 / d41d8 / 932 [ ^ ]
希望它有所帮助。
using this XmlDocument object you can read the nodes and attributes of XML data and save it in DB.
refer the link.
http://stackoverflow.com/questions/11102544/how-to-return-multiple-results-with-xmltable[^]
http://www.sqlfiddle.com/#!4/d41d8/932[^]
hope it helps.