Re: Like Operator with CLOB datatype

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Tue, 21 Nov 2006 05:20:45 GMT
Message-ID: <pan.2006.11.21.05.20.35.790187@verizon.net>

On Mon, 20 Nov 2006 17:26:41 -0800, bala wrote:

> The best thing I thought would be to replace the Datatype from CLOB to
> Varchar2(4000) since I checked the existing Data of that particular
> column and the maximum length was only 500 characters.

The best thing would be to use OracleIntermedia and build text indexes. If my memory serves me well, in Oracle8i, it used to be called Oracle ConText. Of course, the best thing would be to update to 10g. Oracle 8i is an unsupported dinosaur, unknown to practically everybody except Jonathan Lewis.

-- 
http://www.mladen-gogala.com

Received on Mon Nov 20 2006 - 23:20:45 CST