Re: Can I make oracle case sensitive

From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Fri, 10 Sep 1999 17:40:45 +0100
Message-ID: <7rbc94$o22$1@gxsn.com>

Prakash V wrote in message <19990910162311.94400.qmail_at_hotmail.com>...
>In Oracle, the table name and column names are always stored in UPPER case
>only.
>

Not so actually, take the following:

16:34:13 SQL> create table "Customer" ("COLa" number, "COLb" number);

Table created.

real: 922
17:39:08 SQL> desc customer
Object does not exist.
17:39:15 SQL> desc Customer
Object does not exist.
17:39:22 SQL> desc "Customer"

 Name                            Null?    Type
 ------------------------------- -------- ----
 COLa                                     NUMBER
 COLb                                     NUMBER

Jeremy Ovenden
HazelWeb Systems
UK Received on Fri Sep 10 1999 - 11:40:45 CDT