Re: Full text search with XML input in Oracle?
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> | |
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format