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

If you want lower or mixed case table names just to support pretty output, use column aliases in the queries. IMO, you're asking for a whole butt-load of trouble down the road if you pursue this path...

"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 - 21:25:24 CST