Re: Lowercase character

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 10 Jan 2001 12:18:49 -0000
Message-ID: <93hjve$eul$1@soap.pipex.net>

yes it is. It is however a BAD idea.

the work around is to include the column and table name in quotes eg

create table "FoO" ("MixEDcAse" varchar2(255),bar number)

would work. However to work with the resulting table you would have to include the quotes every time you referred to the columns AND get the case exactly right each time. This rapidly becomes a PITA

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Lee" <hengchee.lee_at_aretae.com> wrote in message
news:93hj9t$fkq$1_at_violet.singnet.com.sg...


> Hi,

> Is it possible to give a name to your table and column which contain

> lowercase character in Oracle?

> Even if I typed in lower case when I create table using sqlplus it just

> convert to upper case when I use dbastudio to view the table.

>

>

>

>

> Thanks and best regards

> Lee

>

>

Received on Wed Jan 10 2001 - 06:18:49 CST