RE: XML

From: Ellis R. Miller <sartre1_at_comcast.net>
Date: Thu, 8 Jul 2004 20:19:51 -0600
Message-ID: <AOEDLEKLOHPKBBLDFCLAGEIPDMAA.sartre1@comcast.net>

In general, and this is very general, use a XSLT stylesheet and OracleXMLSave to insert into the relevant table. Were I not approaching my 30th beer...anyway, I will forward the code if nobody else has responded in a few hours. Need to pass out, now.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of SRIDHARAN, SAN (SBCSI)
Sent: Thursday, July 08, 2004 6:24 PM
To: oracle-l_at_freelists.org
Subject: 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

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

----------------------------------------------------------------
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 - 20:03:29 CDT