Re: Case sensitive ORACLE

  i'd like to ask a bit different question : we create tables from Pro/C , and the table&column names are case mixed. Oracle creates them also in case mixed.   However when i try to select them from sqlplus - i have to put the exact table/column names in quotes.

  Is it a possibility to define an alias (or synonym) for a column name ? (i know that for a table i do can create/use a case non-sensitive synonym)

  regards,

                 Avi      aba_at_poboxes.com

"Imtiaz A.Khan" wrote:

> Try
> select name from emp where name =upper'carlos';
>
> Imtiaz
>
> Carlserra wrote:
>
> > 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?
> >
> > Thank you.
> > CARLSERRA

Received on Tue Dec 07 1999 - 03:24:35 CST