Re: Search for text within long field?`

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 05 Jun 2001 19:13:10 +0100
Message-ID: <3B1D2136.6DB1@yahoo.com>

Craig Buchanan wrote:
>
> Is there a way to search for a text string that might exist in a long field?
>
> Something like
>
> SELECT text
> FROM all_views
> WHERE instr(text,'my search') > 0
>
> Thanks,
>
> Craig Buchanan

PL/SQL can be used to get the first 32k (into a varchar2) and then you can instr on that.

You could always try converting it to a lob and running dbms_lob.instr over that.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Tue Jun 05 2001 - 13:13:10 CDT