Re: Can Oracle8 Support This?

From: Jay Walters <jwalters_at_computer.org>
Date: Thu, 29 Apr 1999 10:14:25 -0400
Message-ID: <37286941.F7454D3D@computer.org>

Oracle8i supports indexes of functions, something like upper(foo) can be indexed. It does this by storing the result of the function for every row in the index. When querying against this index you'd have to upper(input) for example to ensure you're putting in an uppercase string.

"Scott J. Hamilton" wrote:

> Does anyone know if Oracle8 supports case insensitive primary indexes? And
> if it does, can you give me an example?
>
> Thanks!
Received on Thu Apr 29 1999 - 09:14:25 CDT