Re: lower case character

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Jan 2001 19:03:38 +0100
Message-ID: <93i97r$ahcqs$4@ID-62141.news.dfncis.de>

Yes it is possible though lower case characters are considered as special, and hence need to be embedded in double quotes like this "emp"
Consequently all your statements are going to need this procedure. You probably don't want that.
In sql*plus you can use
set sqlcase upper
and
select * from user_tables where table_name = 'emp' is automatically converted to uppercase.

Regards,

Sybrand Bakker, Oracle DBA

"Lee" <hengchee.lee_at_aretae.com> wrote in message news:93hjb1$gfl$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 - 12:03:38 CST