Re: OracleXMLQuery

From: guy ruth hammond <grh_at_agency.com>
Date: Tue, 30 May 2000 11:10:16 +0100
Message-Id: <10513.107073@fatcity.com>

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?

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

Received on Tue May 30 2000 - 05:10:16 CDT