XML
- From: "SRIDHARAN, SAN (SBCSI)" <ss4569@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Jul 2004 17:23:41 -0700
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
-------------------------
<CATALOG>
<NATIONS NATION_ID=3D"USA" NAME=3D"United States" DESC=3D"United =
States of
America">
<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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
