From oracle-l-bounce@freelists.org Thu Sep 23 11:46:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8NGkv129857 for ; Thu, 23 Sep 2004 11:46:57 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i8NGkvI29852 for ; Thu, 23 Sep 2004 11:46:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70EA172FA50; Thu, 23 Sep 2004 11:52:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19055-72; Thu, 23 Sep 2004 11:52:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 196D972D85D; Thu, 23 Sep 2004 11:52:42 -0500 (EST) Message-ID: <91719bc4040923094969218ff6@mail.gmail.com> Date: Thu, 23 Sep 2004 12:49:36 -0400 From: Paul Vallee To: oracle-l@freelists.org Subject: Approximating Google syntax when querying Oracle text? Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 9991 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: paulvallee@gmail.com Precedence: normal Reply-To: paulvallee@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hello everyone, Like it or not, (as a shareholder I must say I'm liking it!), everyone knows how to search using Google. However, not everyone knows how to search using Oracle Text. For instance: Google search: "this page intentionally left blank" Text search: this page intentionally left blank Google search: this page intentionally left blank Text search: this and page and intentionally and left and blank etc. etc. etc. etc. Does anyone know if there is any way to easily translate a google-style search query into an Oracle Text contains argument? Bonus points for a solution in perl. :-) Thanks, Paul -- http://www.freelists.org/webpage/oracle-l