Re: CASE sensitive data....

A copy of this was sent to Lisa Lombardo <llombardo_at_courion.com> (if that email address didn't require changing) On Wed, 28 Jul 1999 14:24:56 -0400, you wrote:

>thanks for your input.
>
>Are there settings in ORACLE DB that can override the case-sensitivity
>on a
>column(field) basis?
>

there are not.

>Lisa
>
>Thomas Kyte wrote:
>>
>> >select * from table where upper(first_name)=upper('JoE') and so on.
>> >
>>
>> well, in Oracle8i, release 8.1 we can create an index on upper(first_name) so
>> that a query:
>>
>> select * from table where upper(first_name)=upper('JoE')
>>
>> can and will use an index. see my .sig for a link to a paper on this feature
>> (function based indexes)
>>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jul 28 1999 - 13:28:43 CDT