Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

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

From: Jim Smith <>
Date: Wed, 20 Apr 2005 08:18:03 +0100
Message-ID: <>

In message <hBf9e.14$>, GWood <> writes
>Thanks, Sybrand
>I have been perusing the documentation. As a developer (not a DBA) my
>search is from curiosity. When I asked our DBA staff how a lowercase table
>name could appear in the all_tables view, the answer was "it's impossible,
>Oracle is case-insensitive". Seeing as though I had just spent hours
>tracking down a problem related to a lowercase table name, I found that a
>little terse.
>Another interesting slant is that the Oracle documentation clearly states
>that "names cannot contain quotation marks". However, you can create a
>table using CREATE TABLE XXX."'my_table'". The entire 'my_table' will show
>in the all_tables view, complete with quotation marks. Seems to be contrary
>to the docs?
>Schema Object Naming Rules
>The following rules apply when naming schema objects:
>1. Names must be from 1 to 30 bytes long with these exceptions:
> Names of databases are limited to 8 bytes.
> Names of database links can be as long as 128 bytes.
>2. Names cannot contain quotation marks.
>3. Names are not case sensitive.
>4. A name must begin with an alphabetic character from your database
>set unless surrounded by double quotation marks.
>5. Names can contain only alphanumeric characters from your database
>set and the underscore (_), dollar sign ($), and pound sign (#). Oracle
>discourages you from using $ and #. Names of database links can also contain
>periods (.) and "at" signs (@).

I don't think this describes the actual situation very clearly. It is not wrong, but it would be clearer to say that "any of the above rules may be broken if the name is surrounded by double quotation marks".

I know that MSSQL also supports a similar 'quoted identifier' rule-breaker.

Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .kr .cn .tw
For an explanation see <>
Received on Wed Apr 20 2005 - 02:18:03 CDT

Original text of this message