Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Interesting 8i "mixed case" object name...

Re: Interesting 8i "mixed case" object name...

From: Thomas Kellerer <NNGNVRDSJEBN_at_spammotel.com>
Date: Wed, 20 Apr 2005 09:35:22 +0200
Message-ID: <3cmf1qF6jorlqU1@individual.net>


On 19.04.2005 23:35 GWood wrote:

> Recently had a problem with an IDE for the Silverstream product. During
> it's scanning of the user database, it detected a duplicate table name where
> the two table names were identical but in different cases. Since we all
> know Oracle names are not case sensitive, we got to playing...
>

[...]

> We've fixed the problem, but are curious on how/why Oracle allows this.
> Ideas?

As far as I know this is the behaviour required by the SQL ANSI standard.

Thomas Received on Wed Apr 20 2005 - 02:35:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US