Re: Long Strings in Oracle

Or get Oracle ConText, which is capable of working with contains. This will keep Oracle sales figures up.

Hth,

Sybrand Bakker, Oracle DBA

<bgeake_at_my-deja.com> wrote in message news:7pblu8$sr9$1_at_nnrp1.deja.com...
> I think you're stuck there and will have to retrieve the entire record
> and process on the client side. Unpleasant but then unpleasantness is
> part of what keeps Oracle salaries up. Except mine.
>
> Bill.
>
> In article <7o41kk$6g3_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
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Aug 17 1999 - 13:38:26 CDT