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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Apr 2005 00:03:55 +0200
Message-ID: <1vva61tod66l1rj1is48b8nv09aqtnlnke@4ax.com>

On Tue, 19 Apr 2005 21:35:23 GMT, "GWood" <sorry_at_nothere.com> wrote:

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

Lowercase characters, the - and the space are considered special characters. Special characters need to be embedded in double quotes. This applies to any identifier.
Obviously this is documented, either in the Reference manual or in the Sql reference manual. Please refer to these manuals.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Apr 19 2005 - 17:03:55 CDT