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
Paul,
You could pull out chunks of the LONG with the DBMS_SQL.Column_Value_Long procedure. Using PL/SQL, you would pull out 32K (or any smaller size) chunks, assign them to a VARCHAR and then look for '%fred%' within that chunk. The obvious downsides:
If you know the records that you are searching through are less then 32K, or you are just looking for 'fred' in the first 32K of the record, then Column_Value_Long wouldn't be too horrific.
If you're interested I'll post a PL/SQL procedure for you to do this.
Jay!!!
Paul Smith wrote:
> I would like to add a where clause to a select on a long column, but I always
> get an oracle error stating that there are inconconsistent datatypes
> (ORA-00932). I can't even do a TO_CHAR() on the column. This seems like a big
> oversight to me - is there *any* way to do what I want to do?
>
> --
> Paul Smith
> Technical Manager, SDR Systems Ltd
> Please change Compuserve.comz to Compuserve.com to respond via Email
Received on Wed Oct 21 1998 - 11:09:40 CDT