Re: ALL_IND_COLUMNS

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Wed, 01 Sep 1999 20:30:19 +0200
Message-ID: <37CD70BA.5EEE8693@wxs.nl>

Oracle 8.1 (8i) supports indexing on formula's (eg. index in UPPER(lastname))
These formula's take more space.

Erwin

ray_stanley_at_my-deja.com wrote:

> Does anyone know why Oracle switched the
> ALL_IND_COLUMNS.COLUMN_NAME to varchar2(4000) in
> Oracle 8.0.5.0.0? It would seem that they would
> have left the column at varchar2(30) as was in
> 7.3.4.
>
> Thanks for any info!
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Erwin Dondorp
<http://www.wxs.nl/~erwindon> Received on Wed Sep 01 1999 - 13:30:19 CDT