Sqlloader - loading XML file format of data to tables
I would like to get help on the above. I would like to load a XML file of data, to a temp table with each columns based on xml file.
Could anybody help to advice me ? Im a 1st time user for this community.
my temp table to load the xml data
create table XmlTest
(
Fusion_PO_Number varchar2(150),
Fusion_Trade_Order_Type varchar2(150),
Sold_To varchar2(150),
HP_Order_Number varchar2(150),
Bill_To varchar2(150),
Ship_To varchar2(150),
Customer_PO_Number varchar2(150),
Line_Number varchar2(150),
Action_Code varchar2(150),
Ordered_Quantity varchar2(150),
Unit_Of_Measure varchar2(150),
Plant varchar2(150),
Requested_Delivery_date varchar2(150),