RE: How to search on LONG datatype column

Wouldn't OracleText (now included with EE license) work?

The setup is still a but tricky and try to find resources for creating a = stoplist, but it works great for us. I'm not sure about LONG support, = but it will work with CLOBS.

Just wondering...

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

-----Original Message-----
Sent: Tuesday, October 26, 2004 1:54 PM
To: 'dba.orcl_at_gmail.com'; Oracle Discussion List Subject: RE: How to search on LONG datatype column

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]=20

> Sent: Tuesday, October 26, 2004 2:42 PM

> To: Oracle Discussion List

> Subject: How to search on LONG datatype column

>=20
>=20


> Hi All,

>=20


> I want to search something based on search_condition. Since=20

> search_condition column is LONG data type I could not use=20

> "like" or "=3D" operator.

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l