Re: Case-Sensitivity of Identifier Names

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 10 Jul 2002 18:45:46 GMT
Message-ID: <3D2C80AB.34E97327@exesolutions.com>

Piotr Jozwiak wrote:

> The names of database objects - tables, views, columns, and synonyms - are
> case-sensitive by default in the Oracle database server.
> How to make them case-insensitive?
>
> Example:
>
> CREATE TABLE TABLE_NAME ( COLUMN_NAME NUMBER );
> SELECT "column_name" FROM "table_name";
>
> The select does not work because of case-sensitivity of identifier names.
>
> Thanks,
> Peter

Get the double quotes out of your code. They have no legitimate place anywhere in Oracle SQL except in a VARCHAR2 or CLOB field.

The fact that it is possible to violate good practices with double quotes doesn't mean anyone should.

Daniel Morgan Received on Wed Jul 10 2002 - 13:45:46 CDT