From oracle-l-bounce@freelists.org Tue Oct 26 13:50:32 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9QIoWk01909 for ; Tue, 26 Oct 2004 13:50:32 -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 i9QIoVI01904 for ; Tue, 26 Oct 2004 13:50:32 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A48472E7E5; Tue, 26 Oct 2004 13:56:43 -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 05426-81; Tue, 26 Oct 2004 13:56:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 583D772C80D; Tue, 26 Oct 2004 13:56:34 -0500 (EST) Message-ID: <30462D80AA52E74698512ADCC4F7EAA317C1FC8D@EXCHANGE> From: "Gogala, Mladen" To: "'dba.orcl@gmail.com'" , Oracle Discussion List Subject: RE: How to search on LONG datatype column Date: Tue, 26 Oct 2004 14:54:29 -0400 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 11559 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mladen.Gogala@aetn.com Precedence: normal Reply-To: Mladen.Gogala@aetn.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Try "CONTAINS". You will need to install intermedia, create preferences and index those LONG columns. Oracle*Intermedia is not free software, it has to be purchased. If you don't want to purchase Intermedia, you can convert LONG columns into BFILE and use egrep or perl. Good luck with that. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: Sami Seerangan [mailto:dba.orcl@gmail.com] > Sent: Tuesday, October 26, 2004 2:42 PM > To: Oracle Discussion List > Subject: How to search on LONG datatype column > > > Hi All, > > I want to search something based on search_condition. Since > search_condition column is LONG data type I could not use > "like" or "=" operator. -- http://www.freelists.org/webpage/oracle-l