Re: Case sensitive ORACLE

Two simple solutions come to mind. You can create a view of the table or recreate the table.

1. CREATE VIEW table_view AS SELECT "col1" COL1, "col2" COL2, ... FROM table;
2. CREATE TABLE temp AS SELECT "col1" COL1, "col2" COL2, ... FROM table; DROP TABLE table; CREATE TABLE table AS SELECT * FROM temp;

HTH,
Brian

Avi Veinshtein wrote:
>
> 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 - 09:18:11 CST