Received: (qmail 23737 invoked from network); 6 Jun 2011 11:02:25 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 6 Jun 2011 11:00:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B64BE28F76; Mon, 6 Jun 2011 12:00:55 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1307376055; bh=9Dh6LNNugb1p+4guYnHG+j6iRzrJMOjHzg9r+UPw fWg=; h=Message-ID:References:Date:From:Subject:To:In-Reply-To: MIME-Version:Content-Type:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=IvRjea4JkJooicHjrE/N+HBWIBtqvRTk2mdyjdJDc9H5IZKlfv 3fh8/SodV+QIWZRnkR7H/KmwK3Zh0JKrD3okPLQpsYv6dXq19HN3+EhFaROlo7Z8boo VnQ/Kt7LEU4FNbJUFRvw0IfGQdjNrX3fhfjt983NA1cxtzT00alCls= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id RQDSWkm2xkb5; Mon, 6 Jun 2011 12:00:55 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E563BE28E92; Mon, 6 Jun 2011 12:00:11 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 06 Jun 2011 11:59:29 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98315E28F02 for ; Mon, 6 Jun 2011 11:59:29 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key) header.i=@yahoo.com Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gqLiLQIo0iHp for ; Mon, 6 Jun 2011 11:59:29 -0400 (EDT) Received: from nm23.bullet.mail.ac4.yahoo.com (nm23.bullet.mail.ac4.yahoo.com [98.139.52.220]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id EC9B8E28EF6 for ; Mon, 6 Jun 2011 11:59:27 -0400 (EDT) Received: from [98.139.52.195] by nm23.bullet.mail.ac4.yahoo.com with NNFMP; 06 Jun 2011 15:59:26 -0000 Received: from [98.139.52.184] by tm8.bullet.mail.ac4.yahoo.com with NNFMP; 06 Jun 2011 15:59:26 -0000 Received: from [127.0.0.1] by omp1067.mail.ac4.yahoo.com with NNFMP; 06 Jun 2011 15:59:26 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 967752.37273.bm@omp1067.mail.ac4.yahoo.com Received: (qmail 53705 invoked by uid 60001); 6 Jun 2011 15:59:26 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1307375966; bh=Aqh8xczkjCktHawRAjWpPpfnwbXbpqJiVp6SCdtrjBE=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=jkxKV57lamXJW5DIrjwdHgrwTrEk9Mm9mL0Vgh0vZO+wqdd8lO6yxoPq9hkb19SwVC7C3ROxEyN2vbpqUyOBPRJf7X+PLh5EiIip5YICHH25yB78rk/GwMGH8rpZs1/MNJzM4cMOTybLm3GpeEFt+wxJnektZR4v7/ky3ljrcUg= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=NfT1+xKklFKbdRXw3FIvDMAT36/DZvFF5FwkYi4i2d4Q92xZZ5trP982GcgnLInHAa7mlydJC5o1CYIJEGZsynUdmaVT+Y6Fa4Vmo9TR77Jl05zF5F3Xi7A46nl4FufkKoIIUMOVdFSan60sFal6S6tGTfRHuICt1CKwceOirfM=; Message-ID: <624930.52151.qm@web65401.mail.ac4.yahoo.com> X-YMail-OSG: 1Vora8MVM1mzifL4GKJpM4bQ2bq._457ZtiBCkkuFxVfgms .wq8DMVdvvRIvnGV7kYNmK7ZdEEVCANCHEjzAwhq8i8SQopXHvyA1jZ95.Nn Ohi9pEZkMAGr0ioZ9Bj99wkvJTJHZD8xfUUcEOU_2AEPBTRfIxn6kqwHjK0b 5gpVqbtYxjshJbTUuD7KThWHeXv6wdRx_UR0c4cINbYCnudFQibBkkbngq7f Wvirf6lPC7syh6TzsjB02kjxAR4BxK6XeFEIw1d5mLi_aUJCx.aKwilr4ahP PdwNxrIDVMI1tbzm4IVyV4yCvk1UR.2BTCalRWxM2USC0nJCEjjT6kWORCiE bD6RouKks6kSYkxy_A.cQWzVercd_9i3g7w1VBYMzYcFwkggOY04eqBa9MUp t3bvr9doZTDovr42V6Q6rA71AL.RfGTk0_MNCKQxC92O4Ig2n.waRs67x655 CKhE3XhEKrd0mXzsn0VtKBHDtKy7C2Wk6rfxudCReFacG_M1TJENtH45d_0t ri.h1Bl57n8QsydP63sR5sO7r2dmZSVOqAINuOOY38NkaNHPhbjfa1L3SdWU Gp17mE9OSFuwKQXFJCdaizHIiUwi8uxxWAU9g3e6o_ecn.5mDH5KjNe74HeT umvPeQV56IzwqRmsEdiX8nXHGU3BJqkMaNx50pQ-- Received: from [208.240.243.170] by web65401.mail.ac4.yahoo.com via HTTP; Mon, 06 Jun 2011 08:59:26 PDT References: <34DB87F47199374280ADFD2968CDBCFA8888E92982@MAIL01KT.seattlepacificindustries.com> Date: Mon, 6 Jun 2011 08:59:26 -0700 (PDT) From: David Fitzjarrell Subject: Re: Loading XML into Oracle db To: eugene.pipko@unionbay.com, "oracle-l@freelists.org" In-Reply-To: <34DB87F47199374280ADFD2968CDBCFA8888E92982@MAIL01KT.seattlepacificindustries.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1316068506-1307375966=:52151" X-archive-position: 36592 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: oratune@yahoo.com Precedence: normal Reply-To: oratune@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --0-1316068506-1307375966=:52151 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Using 9.2.0.8 makes this a challenge but read here:=0A=0Ahttp://download.or= acle.com/docs/cd/B10501_01/appdev.920/a96621/adx01bas.htm#1011989=C2=A0=0A= =0A=0AIt recommends using SQL*Loader and gives tips on how to create the lo= ader =0Acontrol file.=C2=A0 Hopefully this will help.=0A=C2=A0=0A=C2=A0=0AD= avid Fitzjarrell=0A=0A=0A=0A=0A=0A________________________________=0AFrom: = Eugene Pipko =0ATo: "oracle-l@freelists.org" =0ASent: Mon, June 6, 2011 8:50:46 AM=0ASubject: Loadi= ng XML into Oracle db=0A=0A=0AHi all,=0AOracle 9.2.0.8 on Win 2003.=0AI nee= d to load an XML file that is coming from Amazon.com site into Oracle =0Ada= tabase. I=E2=80=99ve never done this before and looking for your help.=0AId= eally, (if possible) I think, I want to be able to parse this file and load= =0Aeach element (ItemId, ItemTax, ShippingPrice =E2=80=A6.) in its own tab= le column.=0AIf someone knows =C2=A0a good site to learn from, please share= a link to it.=0AHere is the sample file:=0A=C2=A0=0A=0A=0A=0A=C2=A0 305-341322= 2-1220037=0A=C2=A0=C2=A0=0A=C2=A0=C2=A0=C2=A0 <= OrderItem>=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 B0050FWB6G=0A=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 06782084248170=0A=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 Y18WW31_173Y_29=0A=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 SURVIVOR SHORT=0A=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 1=0A=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 0=0A=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = 19.99=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <= CurrencyCode>USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 0.00=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0 =C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0USD=0A=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 4.49=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <= /ShippingPrice>=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 USD=0A=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0.00=0A=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0.00=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 0.00=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =0A=C2=A0= =C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 BKF50FWBAA<= /ASIN>=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 06782084215425=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Y18WW81_100Y_30=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 SURVIVOR PANT=0A=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 1=0A=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 0=0A=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 17.99=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 0.00=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 USD=0A=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 4.49=0A=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0.00=0A= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 =0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 USD=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0.00=0A=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =0A=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 USD=0A=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 0.00=0A=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 =0A=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0= =C2=A0 =0A=C2=A0 =0A=0A=0A=C2=A0 5df298d9-b6b7-4a89-a97f-42b8c971a553=0A<= /ResponseMetadata>=0A=0A=C2=A0=0A=C2=A0=0AThanks,= =0AEugene --0-1316068506-1307375966=:52151 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
=0A
Using 9.2.0.8 makes this a challenge but read h= ere:
=0A=0A
=  
=0A
It recommends using SQL*Loader and gives tips on how to= create the loader control file.  Hopefully this will help.
=0A 
=0A
 
=0A
David Fitzjarrell
=0A
&= nbsp;
=0A

=0A

=0A
=0A
=0AFrom:<= /B> Eugene Pipko <eugene.pipko@unionbay.com>
To: "oracle-l@freelists.org" <oracle-l@freeli= sts.org>
Sent: Mon, J= une 6, 2011 8:50:46 AM
Subject: Loading XML into Oracle db

=0A=0A=0A
=0A

Hi all,

=0A

Oracle 9.2.0.8 on Win 2003.

= =0A

I need to load an XML file that is coming from Amazon.com site into Oracle = database. I=E2=80=99ve never done this before and looking for your help.=0A

Ideally, (if possible) I think, I want to be able = to parse this file and load each element (ItemId, ItemTax, ShippingPrice = =E2=80=A6.) in its own table column.

=0A

If someone = knows  a good site to learn from, please share a link to it.

=0A

Here is the sample file:

=0A

 = ;

=0A

<?xml version=3D"1.0"?>

=0A

<ListOrderItemsResponse xmlns=3D"https://mws.amazonservices= .com/Orders/2011-01-01">

=0A

<ListOrderItemsRe= sult>

=0A

  <AmazonOrderId>305-3413222= -1220037</AmazonOrderId>

=0A

  <O= rderItems>

=0A

    <OrderItem&g= t;

=0A

      <ASIN>B0= 050FWB6G</ASIN>

=0A

    &n= bsp; <OrderItemId>06782084248170</OrderItemId>

=0A

      <SellerSKU>Y18WW31_173Y_2= 9</SellerSKU>

=0A

    &nbs= p; <Title>SURVIVOR SHORT</Title>

=0A

&nb= sp;     <QuantityOrdered>1</QuantityOrdered>= ;

=0A

      <QuantityShi= pped>0</QuantityShipped>

=0A

  &n= bsp;   <ItemPrice>

=0A

  &= nbsp;     <CurrencyCode>USD</CurrencyCode><= /P>=0A

        <A= mount>19.99</Amount>

=0A

   =    </ItemPrice>

=0A

  &nbs= p;   <ItemTax>

=0A

   = ;     <CurrencyCode>USD</CurrencyCode>

= =0A

        <Amou= nt>0.00</Amount>

=0A

   &nbs= p;  </ItemTax>

=0A

   &nbs= p;  <ShippingPrice>

=0A

   &nbs= p;    <CurrencyCode>USD</CurrencyCode>

= =0A

        <Amou= nt>4.49</Amount>

=0A

   &nbs= p;  </ShippingPrice>

=0A

  &nbs= p;   <ShippingTax>

=0A

  &= nbsp;     <CurrencyCode>USD</CurrencyCode><= /P>=0A

        <A= mount>0.00</Amount>

=0A

   &= nbsp;  </ShippingTax>

=0A

  &nb= sp;   <ShippingDiscount>

=0A

 &= nbsp;      <CurrencyCode>USD</CurrencyCod= e>

=0A

       = <Amount>0.00</Amount>

=0A

  &= nbsp;   </ShippingDiscount>

=0A

&nbs= p;     <PromotionDiscount>

=0A

        <CurrencyCode>USD<= /CurrencyCode>

=0A

     =    <Amount>0.00</Amount>

=0A

&= nbsp;     </PromotionDiscount>

=0A

    </OrderItem>   

=0A

    <OrderItem>

=0A

      <ASIN>BKF50FWBAA</ASIN>=0A

      <OrderItemId>= ;06782084215425</OrderItemId>

=0A

  =     <SellerSKU>Y18WW81_100Y_30</SellerSKU>

= =0A

      <Title>SURVIVO= R PANT</Title>

=0A

    &nb= sp; <QuantityOrdered>1</QuantityOrdered>

=0A

      <QuantityShipped>0</QuantitySh= ipped>

=0A

      <Ite= mPrice>

=0A

      &= nbsp; <CurrencyCode>USD</CurrencyCode>

=0A

        <Amount>17.99</Amoun= t>

=0A

      </ItemPr= ice>

=0A

      <ItemT= ax>

=0A

       = ; <CurrencyCode>USD</CurrencyCode>

=0A

&= nbsp;       <Amount>0.00</Amount>=

=0A

      </ItemTax>=

=0A

      <ShippingPric= e>

=0A

       = <CurrencyCode>USD</CurrencyCode>

=0A

&n= bsp;       <Amount>4.49</Amount><= /P>=0A

      </ShippingPric= e>

=0A

      <Shippin= gTax>

=0A

      &nb= sp; <CurrencyCode>USD</CurrencyCode>

=0A

        <Amount>0.00</Amount&g= t;

=0A

      </ShippingT= ax>

=0A

      <Shippi= ngDiscount>

=0A

     &nb= sp;  <CurrencyCode>USD</CurrencyCode>

=0A

        <Amount>0.00</Am= ount>

=0A

      </Shi= ppingDiscount>

=0A

     = <PromotionDiscount>

=0A

   &nb= sp;    <CurrencyCode>USD</CurrencyCode>

=0A        <Amount>= ;0.00</Amount>

=0A

    &nb= sp; </PromotionDiscount>

=0A

   = ; </OrderItem>   

=0A

  &= lt;/OrderItems>

=0A

</ListOrderItemsResult>=

=0A

<ResponseMetadata>

=0A

  <RequestId>5df298d9-b6b7-4a89-a97f-42b8c971a553</Reque= stId>

=0A

</ResponseMetadata>

=0A

</ListOrderItemsResponse>

=0A

&n= bsp;

=0A

 

=0A

Thanks,=0A

Eugene

=0A

 

--0-1316068506-1307375966=:52151-- -- http://www.freelists.org/webpage/oracle-l