Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to search a LONG column

Re: How to search a LONG column

From: Brian Everett <beverett_at_remove_this.usa.net>
Date: 1998/03/29
Message-ID: <352076cb.308157446@news.earthlink.net>#1/1

You may want to consider the Context Option. I store many forms of documents in Long fields that are indexed for all types of searches.

On Fri, 27 Mar 1998 09:27:09 -0500, Cary Moore <cjmoore_at_compuserve.com> wrote:

>
>
>According to the docs you can't reference a LONG column in a WHERE clause,
>one of the many restrictions with LONGS!
>
>Part of our application allows users to set filter conditions including
>the ability to word search, is there any way we can word search text
>stored in a LONG?
>
>Cary

Good Luck! Brian_RestonVA Received on Sun Mar 29 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US