Re: Case-Sensitivity of Identifier Names

From: Jim Lyons <jlyons_at_weblyons.com>
Date: 10 Jul 2002 14:28:31 -0700
Message-ID: <e67857c9.0207101328.766b8d95@posting.google.com>

"Piotr Jozwiak" <pjozwiak_at_poczta.onet.pl> wrote in message news:<aghr0p$qo2$1_at_kujawiak.man.lodz.pl>...
> 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.

Lose the double quotes.

Identifiers are case insensitive by default in Oracle. You only need to be concerned with case when dealing with literal strings.

For example:

select table_name from user_tables

is perfectly fine.

select table_name from user_tab_columns where column_name = 'id'

won't get you anything but

select table_name from user_tab_columns where column_name = 'ID'

will.

---

Jim Lyons
DBA
UT Austin Received on Wed Jul 10 2002 - 16:28:31 CDT