Re: XML

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Mon, 25 Sep 2000 10:41:33 +0300
Message-Id: <10630.117738@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C026DD.2BE63930 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

U may wish to take a look at the DOM/SAX parsers for C++,Java,PL/SQL - = http://technet.oracle.com/tech/xml/

U can also take a look at the Xml Sql Utility = (http://technet.oracle.com/tech/xml/oracle_xsu/) which allows u to "pass = a query to the database and generate an XML document (text or DOM) from = the results" or "write XML data to a database table"=20

hth,

Marin

"When brought to meaning, all importance becomes small, as in death,=20 all life seems nothing. Knowing is destroyed by thinking,=20 distilled into knowledge"

                                                 William Wharton, =

"Birdy"

Original Message -----=20 From: Ken Gerrbo=20 To: Multiple recipients of list ORACLE-L=20 Sent: Saturday, September 23, 2000 03:14 Subject: XML=20

Hi Guru's=20

What is the best way to parse XML to an oracle 8i database, I am = desingning an e-application that is splitting XML files , with fields .I = want to parse the XML messages to my database . Any Ideas any one did = before and what are the best approches . Thanks ,

------=_NextPart_000_0018_01C026DD.2BE63930 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>
<DIV> </DIV>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>U may wish to take a look at the DOM/SAX parsers for =
C++,Java,PL/SQL - <A=20
href=3D"http://technet.oracle.com/tech/xml/">http://technet.oracle.com/te= ch/xml/</A></DIV>
<DIV> </DIV>
<DIV>U can also take a look at the Xml Sql Utility (<A=20
href=3D"http://technet.oracle.com/tech/xml/oracle_xsu/">http://technet.or= acle.com/tech/xml/oracle_xsu/</A>)=20
which allows u to "<FONT size=3D2>pass a query to the database and = generate an XML=20
document (text or DOM) from the results</FONT>" or "<FONT = size=3D2>write XML=20
data to a database table</FONT>" </DIV>
<DIV> </DIV>
<DIV>hth,</DIV>
<DIV> </DIV>
<DIV>    Marin</DIV>
<DIV> </DIV>
<DIV>---------</DIV>
<DIV> </DIV>
<DIV>"When brought to meaning, all importance becomes small, as in =
death,=20
<BR>all life seems nothing. Knowing is destroyed by thinking, =
<BR>distilled into=20

knowledge"</DIV>
<DIV> </DIV>
<DIV>           &n=

bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=

;=20
William Wharton, "Birdy"</DIV></FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:ken_gerrbo_at_yahoo.com" = title=3Dken_gerrbo_at_yahoo.com>Ken=20
  Gerrbo</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Saturday, September 23, = 2000=20
  03:14</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> XML </DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>Hi Guru's </FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; What is the best =

way to parse=20
XML to an oracle 8i database, I am desingning an e-application that is =

splitting XML files , with fields .I want to parse the XML messages to = my=20
database . Any Ideas any one did before and what are the best = Received on Mon Sep 25 2000 - 02:41:33 CDT