XML to Oracle

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

Questions by violet_wings_vamsi

Showing Answers 1 - 3 of 3 Answers

IanJoshua

  • Jul 8th, 2008
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions