Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Would like to do .... LIKE '%fred%' on LONG column
You have to use dynamic sql (see DBMS_SQL package) and process the long in
chunks. Hopefully your column is a LONG and not a LONG RAW, because then
you're really out of luck. Oracle7 has support for dynamic sql.
Jeremy Ovenden wrote in message <70l77e$i8u$1_at_newnews.global.net.uk>...
>Does this imply that you CAN do it on 8?
>Ian Hughes wrote in message <362DDF78.8C3EC036_at_capgemini.co.uk>...
>>You can't do this with LONGs in v7 - you can't actually do much with LONGS
>in
>>v7.
>>
>>Georg Verweyen wrote:
>>
>>> Paul Smith wrote:
>>> >
>>> > I would like to add a where clause to a select on a long column, but
..
>
>>
>
>
Received on Wed Oct 21 1998 - 20:01:54 CDT
![]() |
![]() |