How do you load data from XML file to a ORACLE table?

IanJoshua

 Profile Answers by IanJoshua Questions by IanJoshua

• Jul 8th, 2008

This is from XML to sqlserverexce sp_xml_preparedocument @inthandle int output,@xmldocumentselect * from openxml(@inthandle,'/root/customer',2)with (customerid varchar(10),      contactname varchar(20))exec sp_xml_removedocument @inthandle

Answer Question  Select Best Answer