| Duplicated object [message #37347] |
Fri, 01 February 2002 07:24  |
Luca
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
Hi All,
a simple (I hope) question from an Oracle beginners. 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 (8.0.5 on Unixware) 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
|
|
|
|
| Re: Duplicated object [message #37351 is a reply to message #37347] |
Fri, 01 February 2002 10:49  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
it's not Unixware, it's your DDL syntax.
create table "PippO" (...); is different to:
create table pippo (...); OR
create table PIPPO (...);
Without quotes (much preferred) you get an upper case tablename.
Many tools use quotes to preserve the case, but you shouldn't be using them.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
