XML

From: SRIDHARAN, SAN (SBCSI) <ss4569_at_sbc.com>
Date: Thu, 8 Jul 2004 17:23:41 -0700
Message-ID: <D363ADA29513DD4C879B4275920327DED102E1@cafrfd1msgusr02.itservices.sbc.com>

Hello,

I have an xml file as below. I have to read this XML file and find the following value and store it into the DB

Name =3D Arkansas
Billing_system =3D TLG
Postal_code =3D 72358

Please let me know how we can do this.

Thanks

Portion of the XMl file

        <REGIONS REGION_ID=3D"CEN" NAME=3D"Central" DESC=3D"Central">
          <MARKETS MARKET_ID=3D"ARK" NAME=3D"Arkansas" =
DESC=3D"Arkansas">
             <SUBMARKETS SUBMARKET_ID=3D"FAY" BILLING_SYSTEM=3D"TLG"
NAME=3D"Fayetteville/Washington" DESC=3D"Fayetteville/Washington">
                            <POSTAL_CODES POSTAL_CODE=3D"72358"/>
                            <POSTAL_CODES POSTAL_CODE=3D"72442"/>
                            <POSTAL_CODES POSTAL_CODE=3D"72659"/>
                            <POSTAL_CODES POSTAL_CODE=3D"72701"/>
                            <POSTAL_CODES POSTAL_CODE=3D"72702"/>
                            <POSTAL_CODES POSTAL_CODE=3D"72703"/>

.
.
.
.
.
.
.
.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 08 2004 - 19:20:45 CDT