RE: How to search on LONG datatype column
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <Mladen.Gogala@xxxxxxxx>, <dba.orcl@xxxxxxxxx>, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Oct 2004 14:43:57 -0500
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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
-----Original Message-----
Sent: Tuesday, October 26, 2004 1:54 PM
To: 'dba.orcl@xxxxxxxxx'; 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@xxxxxxxxx]=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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
