Re: duplicated object

In DDL commands, object (table) names are converted to upper case so:

    create table fred ...

is the same as

    create table FRED

You can mixed case objects by enclosing the object name in double quotes e.g.

 create table "Fred" ...

No-one does it because it's a pain in the bum when coding as you have to reference the object in the same way i.e.

 select * from "Fred"

Luca Saccarola <lsaccarola_at_computercenter.it> wrote in message news:Pine.WNT.4.33.0202011841061.1356-100000_at_w-saccarol...
> Hi All,
>
> a simple (I hope) question from an Oracle beginners. I'm using Oracle
> 8.0.5 on Unixware 7.0.1. The statement
>
> select table_name from user_tables where upper(table_name) = 'PIPPO'
>
> give me
>
> PIPPO
> Pippo
>
> So I've assumed that the db installation I'm playing with is case
> sensitive but when I've tried to create a new table named 'PippO' I've
> got:
>
> ORA-955: name is already used by an existing object
>
> Any tips ?
>
> Regards
>
>
Received on Fri Feb 01 2002 - 15:50:41 CST