Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Search in a long field

Re: Search in a long field

From: Paul Cluiss <paul_cluiss_at_intervoice.com>
Date: Wed, 23 Feb 2000 10:05:10 -0600
Message-ID: <7EA62157B9E7C1FB.3D65DC3CE3EA4617.8FAD872F2EDB3645@lp.airnews.net>


If you're doing wildcard searches you can use the LIKE keyword in your SQL queries. LIKE also works in PL/SQL IF statements.

Hope this helps,

Paul Cluiss
Richardson, Texas

Stefano Fronteddu wrote:

> Hi to you,
> I've a problem. I use a long field to put a String into it. Now I have to
> make a search in that field ... how can I do such a thing ?
> Thanks a lot, bye,
> Stefano
>
> --
> ---
> Dott.Ing. Stefano Fronteddu (TMD)
> Datanord Multimedia E-mail: fronteddu_at_dnm.it
> Via Tortona, 31 WWW: http://www.datanord.it/
> 20144 Milano - Italy Phone: +39 02 4895 61 - Fax: +39 02 489561
Received on Wed Feb 23 2000 - 10:05:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US