Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Two tables with same name, one uppercase, one lowercase
Zar,
whether you select from WEIRDTABLE or weirdtable it's exactly the same thing - Oracle being (contrarily to Sybase for instance) case-insensitive, the name is translated to uppercase and in both cases you select from WEIRDTABLE. If you want to select from the other table (which actually exists) you must type
select * from "weirdtable"
The double quotes prevent Oracle from changing the name. For you information, anything is valid (including spaces and control characters) between double quotes as long as you do not break the 30-character barrier. You sometimes have those identifiers which appear in lowercase in dictionary tables with applications whiche were migrated from another, case-sensitive, system to Oracle.
--
Regards,
Stéphane Faroult
Oriole Corporation