Re: Long Strings & Oracle

you can install the context option ,which allows you to include the CONTAIN clause in the sql statement.

Sudershan Virdi

kal121_at_my-deja.com wrote:

> Oracle 8 has varchar2(4000)
> or you can store one line at a time,
> each line being a separate row.
>
> In article <7o41rm$6sa_at_news-central.tiac.net>,
> "Hank Riehl" <hankr_at_skillview.com> wrote:
> > We'd like to add the capability for our application to store an
> > employee's resume and permit management to run keyword search queries
> > against the resume library using LIKE or CONTAINS in the WHERE clause.
> >
> > Oracle 7.x seems to have a 2000 character limitation on the VARCHAR2
> > datatype which is too few characters. The Oracle LONG datatype does
> not
> > permit references to it in a SQL WHERE clause.
> >
> > Any ideas on how to achieve this functionality? I can't believe that
> > Oracle's character-handling is so restrictive.
> >
> > Thanks... Hank Riehl
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 13:23:13 CDT