Re: Case sensitive ORACLE

"Carlserra" <carlserra_at_hotmail.com> writes:

> Hi:
>
> I have a problem. Oracle is case sensitive. Is there any flag or any special
> configuration to convert Oracle to not case sensitive.
>
> Example:
>
> When a use select...
>
> select name from emp where name ='CARLOS'
> select name from emp where name ='carlos'
>
> 'CARLOS' is diferent than 'carlos' but i donīt want.
> I want that 'CARLOS' = 'carlos'
>
> It's impossible?

No,

 select name from emp where upper(name) = upper('CARLOS');  select name from emp where upper(name) = upper('carlos');

for example.

Hope this helps

Phil

--
Philip W. Britton
Productisation & Support Manager (Asset Lifecycle Databases) PrismTech Ltd, UK.
Tel +44 191 497 9919 http://www.prismtechnologies.com Received on Mon Nov 29 1999 - 08:13:16 CST