Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Interesting 8i "mixed case" object name...
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