Database Utilities (MOSC)

MOSC Banner

Sqlloader - loading XML file format of data to tables

edited Jan 19, 2010 3:02AM in Database Utilities (MOSC) 5 commentsAnswered
 Hi,

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), 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center