| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OracleXMLQuery
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFCA4B.F4A4B100
Content-Type: text/plain;
charset="iso-8859-1"
So to use this feature I need to write java program or stored procedure? Any such feature in PL/SQL? Where can I find it, description?
Alex Hillman
-----Original Message-----
From: guy ruth hammond [mailto:grh_at_agency.com]
Sent: Tuesday, May 30, 2000 7:16 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: OracleXMLQuery
Andrey Bronfin wrote:
> > Dear DBAs ! > Another question that i can't find an answer for : > > what is OracleXMLQuery ?
It's a Java class for taking a SQL statement, running it against a database, and returning the results in an XML document. The opposite is OracleXMLSave, which takes an XML document and writes it into Oracle tables.
> BTW , i'm storing XML files as CLOBs . Is there a better way to store > XML in DB ?
That depends. XSU (the Oracle XML SQL Utilities) are happy enough assembling XML from relational tables. Other bits of Oracle, for example interMedia Text are happier with large chunks of plain XML that they can index themselves. What is your application?
g
-- guy ruth hammond <grh_at_agency.com> | One is punished for being Technology Analysis & Consulting | weak, not for being cruel. 07879607148 http://www.agency.com | -- Baudelaire -- Author: guy ruth hammond INET: grh_at_agency.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01BFCA4B.F4A4B100 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Tue May 30 2000 - 10:30:16 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: OracleXMLQuery</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>So to use this feature I need to write java program =
or stored procedure? Any such feature in PL/SQL? Where can I find it, = description?</FONT></P>
<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: guy ruth hammond [<A =
HREF=3D"mailto:grh_at_agency.com">mailto:grh_at_agency.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, May 30, 2000 7:16 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: OracleXMLQuery</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Andrey Bronfin wrote:</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Dear DBAs !</FONT>
<BR><FONT SIZE=3D2>> Another question that i can't find an answer =
for :</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> what is OracleXMLQuery ?</FONT>
</P>
<P><FONT SIZE=3D2>It's a Java class for taking a SQL statement, running =
it against</FONT>
<BR><FONT SIZE=3D2>a database, and returning the results in an XML =
document. The</FONT>
<BR><FONT SIZE=3D2>opposite is OracleXMLSave, which takes an XML =
document and writes</FONT>
<BR><FONT SIZE=3D2>it into Oracle tables.</FONT>
</P>
<P><FONT SIZE=3D2>> BTW , i'm storing XML files as CLOBs . Is there =
a better way to store </FONT>
<BR><FONT SIZE=3D2>> XML in DB ?</FONT>
</P>
<P><FONT SIZE=3D2>That depends. XSU (the Oracle XML SQL Utilities) are =
happy enough</FONT>
<BR><FONT SIZE=3D2>assembling XML from relational tables. Other bits of =
Oracle, for</FONT>
<BR><FONT SIZE=3D2>example interMedia Text are happier with large =
chunks of plain</FONT>
<BR><FONT SIZE=3D2>XML that they can index themselves. What is your =
application?</FONT>
</P>
<P><FONT SIZE=3D2>g</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>guy ruth hammond <grh_at_agency.com> | One is =
punished for being</FONT>
<BR><FONT SIZE=3D2>Technology Analysis & Consulting | weak, =
not for being cruel.</FONT>
<BR><FONT SIZE=3D2>07879607148 <A HREF=3D"http://www.agency.com" =
TARGET=3D"_blank">http://www.agency.com</A> = | -- Baudelaire</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: guy ruth hammond</FONT>
<BR><FONT SIZE=3D2> INET: grh_at_agency.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |