Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> XML
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"/>
-- 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
![]() |
![]() |