OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] Full text search with XML input in Oracle?

[ Lists Home | Date Index | Thread Index ]


Oracle can definitely do this.

In Oracle8i, release 8.1.7, you can do it with syntax that looks like:

   WHERE CONTAINS( your_column_name_with_xml_in_it,
                   'hello WITHIN title') 
     OR  CONTAINS( your_column_name_with_xml_in_it,
                   'hello WITHIN article') 

or if you meant to find "hello" within the <title> element only
when it is also nested within an <article> element, you would do:

   WHERE CONTAINS( your_column_name_with_xml_in_it,
                   'hello WITHIN title WITHIN article') 

My "Building Oracle XML Applications" book from O'Reilly has
a chapter on using XML searching in Oracle8i 8.1.7.

Oracle9i Release 2 has significantly enhanced our XML features
in the database, and along with them, text searching functionality
for XML has been dramatically improved as well.

Here's a pointer to our online documentation for the
Oracle9i Release 2 database XML features (our latest production


(watch for URL truncation by your email program!) :-)

Steve Muench - Developer, Product Mgr, Java/XML Evangelist, Author
Simplify J2EE Development with the Oracle BC4J Framework
Dive into BC4J at http://radio.weblogs.com/0118231/
Try the BC4J Toy Store Demo at http://www.geocities.com/smuench/bc4jtoystore
Building Oracle XML Apps, http://www.oreilly.com/catalog/orxmlapp

----- Original Message ----- 
From: "Jack Liu" <jianchunliu@yahoo.com>
To: <xml-dev@lists.xml.org>
Sent: Monday, March 31, 2003 23:24
Subject: [xml-dev] Full text search with XML input in Oracle?

| Hi, All,
| I need to do a full text search web application for a
| library based on Oracle database. I will use XML file
| as input and store them in Oracle, the search should
| do not only for text but also for different tags or
| elements. e.g search "hello" from title or from
| article. That means do not convert XML file into ASCII
| file which will be stored in DB.
| Can Oracle(Intermedia text or Oracle Text) do this?
| Any suggestion or referrence?
| Thanks,
| Jack
| __________________________________________________
| Do you Yahoo!?
| Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
| http://platinum.yahoo.com
| -----------------------------------------------------------------
| The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
| initiative of OASIS <http://www.oasis-open.org>
| The list archives are at http://lists.xml.org/archives/xml-dev/
| To subscribe or unsubscribe from this list use the subscription
| manager: <http://lists.xml.org/ob/adm.pl>


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS