Re: Search for text within long field?`

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 5 Jun 2001 00:21:36 +0200
Message-ID: <tho2bjb6pp3f57@beta-news.demon.nl>

"Craig Buchanan" <craibuc_at_hotmail.com> wrote in message news:87910090.0106041200.122b6a9d_at_posting.google.com...
> 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

You'll need Oracle Intermedia, providing the contains operator to search in long text. Intermedia is shipped with the Enterprise Edition only.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Jun 04 2001 - 17:21:36 CDT