Re: How to name my table and column name using lower case letter?

Use literal strings, ie:

create table 'blah' (col1 char(5));

...will create a table permanently identified as blah (lowercase) instead of BLAH. And every time you do a 'select from blah', Oracle will tell you that the table doesn't exist -you'll have to do select from 'blah' instead. Quite why you'd want to put yourself through that sort of hassle, I can't imagine.

Regards
HJR "Lee" <hengchee.lee_at_aretae.com> wrote in message news:937ae0$cev$1_at_violet.singnet.com.sg...
> Hi,
> My question may sound stupid but I just can't named my table and column
 name
> using small letter. Every time I create a new table using dbastudio, when
 I
> need to give my table and table's column a name the character I typed all
> become capital letter even if I don't press shift key or Caps Lock key. Is
> it possible to give a table's name (and column's name) which consists of
> small letter in Oracle8i? I can do it in MS SQL server.
>
>
>
> Thanks and best regards
> Lee
>
>
Received on Sat Jan 06 2001 - 14:40:16 CST