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

You can by enclosing the table name and field names in " 's . However, that means that you will have to write all your queries with those quotes also. create table "lowercase" (
"field1" varchar2(35),
....)
Why do the table and field names have to be lower case? Ascetics? Jim

"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 - 09:22:37 CST