Re: Can I make oracle case sensitive

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Fri, 10 Sep 1999 11:23:51 -0400
Message-ID: <37D92287.3CB41BF1@fmr.com>

SQL is not case sensitive and you cannot make it case-sensitive. Why does it make a difference?

To make column names case-sensitive, use them with double quotes. Like: create table ugly( "column" number, "COLUMN" number );

Regards,
Karen Abgarian.

Brant Remenda wrote:

> Is it possible to make Oracle case sensitive. I am using Oracle 8 and would
> like to make it case sensitive so that an SQL statement such as:
> Select * from Customers
> would not work if the Customers table is spelled CUSTOMERS
>
> I would also like to make columns case sensitive.
>
> Thanks in advance
> Brant
Received on Fri Sep 10 1999 - 10:23:51 CDT