Re: Oracle case senseitivity??

> Hi there
>
> Within Oracle dictionary, all the database objects are stored in upper
> case. For example if you create a table called 'emp'. then it is stored in
> UPPER case.
>
> Normally ORACLE is case in-sensitive as far data dictionary is concerned.
> You can reference 'emp' table as EMP, emp, Emp.
>
> Regards
>
> N.Prabhakar

The above is true if done through SQL however it is possible to get mixed case in the data dictionary, normally through using tools like access.

You could possibly end up with objects named thus :-

Employee, JayTemp, etc.

The way to deal with this is to enclose the mixed case word in double quotes, when referring to the item.

It is probably best IMHO if these items are renamed.

Glenn. Received on Thu Nov 28 1996 - 00:00:00 CET