How do you load data from XML file to a ORACLE table?
This is from XML to sqlserver
exce sp_xml_preparedocument @inthandle int output,@xmldocument
select * from openxml(@inthandle,’/root/customer’,2)
with (customerid varchar(10),
contactname varchar(20))
exec sp_xml_removedocument @inthandle
Explore posts in the same categories: XML Interview Questions