Cart
[Home] [By Thread] [By Date] [Recent Entries]
Jack,
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
release).
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/docindex.htm#index-XML
(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
http://otn.oracle.com/products/jdev/htdocs/j2ee_bc4j.html
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>
|
|
|
