Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle long datatype - finding a substring
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