Re: query on Long data type

Another option to look into is the advanced indexing technology of OMNIDEX from DISC (Dynamic Information Systems Corporation).

(Attention: Promotional information follows. Please disregard if not interested in another solution.)

OMNIDEX uses specialized Multidimensional Keyword Indexes to deliver full text searches and unlimited multidimensional analysis by any number of criteria or columns, including LONGs. OMNIDEX layers on top of your existing database, and it supports numerous databases and document files, including Oracle, SQL Server, Informix, Sybase, flat files, HTML and Word documents.

OMNIDEX is ideal for ad-hoc querying, and it works well for both high and low cardinality data. It is very efficient in terms of build time and disk space.

How much OMNIDEX can help depends on your needs and environment. If you would be interested in a free performance analysis or more information, please contact me.

Cheryl Grandy
DISC
cgrandy_at_disc.com
303 444-4000
www.disc.com/home

OMNIDEX - for the fastest applications ever!

In article <qG_M4.160832$AT6.227472_at_dfw-read.news.verio.net>,   "kdc" <kcameron_at_navicsys.com> wrote:
> Long Columns can not be used in the where clause. Your options are
 few and
> vary depending on the version of oracle you are using:
>
> 1) Install Oracle ConText/or Intermedia Text which will allow you to
> reference Longs in a where clause.
>
> 2) Convert the Longs to LOB's
>
> <colormouse_at_my-deja.com> wrote in message
> news:8dte56$6aa$1_at_nnrp1.deja.com...
> > Experts:
> >
> > I stored the body of the posting into database as LONG data type
> > since they are characters more than 4000. I tried to query this
 field
> > like: (select * from t_posting where body like '%keyword%'), failed
> > because Oracle pop up a error: ORA-00997: illegal use of LONG
 datatype.
> > I can do this query against Varchar2 but this data type too small.
> > Please tell me how do the query like this asap (deadline is
> > comming).
> > Thanks a lot.
> >
> > Color Mouse
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever


Sent via Deja.com http://www.deja.com/
Before you buy.