Re: Naming Tables & Columns

Gennady wrote:
>
> Hello,
> I know that Oracle is not case sensitive but when
> I created table name like my_table I have got MY_TABLE.
> The same is with columns names.
> How can I manage upper / low case Oracle naming representation?
> I use PO8 under NT.
>
> Gennady.

Oracle automatically converts table and column names to upper-case. If you want to have lower-case names, then you need to enclose them in double quotes like this:

create table "blahblah"...

The same with column names. But in doing so, you must also use the double quotes whenever you reference the table like this:

desc "blahblah";

Also, because Oracle treats anything inside double quotes as exactly the way it is, you can have names that are reserved Oracle words, which could be problematic.

Feng Received on Wed Apr 28 1999 - 18:09:09 CDT