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: oracle long datatype - finding a substring

Re: oracle long datatype - finding a substring

From: <nomail_at_nowhere.fr>
Date: 1997/09/15
Message-ID: <341CF179.3D5F814A@nowhere.fr>#1/1

As far as I know, the only way is to use PRO*C or better OCI (whith Piece Fetch).
No sql function accept long. Of course if your string is smaller than 32K you can use PL/SQL.

Ceri Moran wrote:

> Hi
>
> Does anyone know how to find a substring in a long datatype, within a
> table.
>
> Oracle does not let me to a like %string%.
>
> Thank you
>
> Ceri Moran
Received on Mon Sep 15 1997 - 00:00:00 CDT

Original text of this message

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