Try "CONTAINS". You will need to install intermedia, create preferences
and index those LONG columns. Oracle*Intermedia is not free software,
it has to be purchased. If you don't want to purchase Intermedia, you can
convert LONG columns into BFILE and use egrep or perl. Good luck with that.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Sami Seerangan [mailto:dba.orcl_at_gmail.com]
> Sent: Tuesday, October 26, 2004 2:42 PM
> To: Oracle Discussion List
> Subject: How to search on LONG datatype column
>
>
> Hi All,
>
> I want to search something based on search_condition. Since
> search_condition column is LONG data type I could not use
> "like" or "=" operator.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 26 2004 - 13:50:32 CDT
