[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Full text search with XML input in Oracle?

  • To: "Jack Liu" <jianchunliu@y...>
  • Subject: Re: Full text search with XML input in Oracle?
  • From: "Steve Muench" <Steve.Muench@o...>
  • Date: Tue, 1 Apr 2003 15:24:25 +0200
  • Cc: "Xml-Dev" <xml-dev@l...>
  • References: <20030331212441.37235.qmail@w...>

oracle full text search

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@y...>
To: <xml-dev@l...>
Sent: Monday, March 31, 2003 23:24
Subject:  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>


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.