Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to search a LONG column
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