Case-Sensitivity of Identifier Names

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 Received on Wed Jul 10 2002 - 12:28:42 CDT