Re: Column name in lower case in 8.1

You can do this with tables too:

Create table "MonTable" ( "MonColumn" number);

However, if you create tables or columns this way you can only use them correct-case and quoted, in any context.

so for example

select moncolumn from montable;
select MonColumn from MonTable;

do not work. Unquoted names get upper-cased in all situations prior to checking for their existence and the Oracle SQL parser regards all names as case-sensitive.

Only

select "MonColumn" from "MonTable" ;

would work for the above table.

I would say in Oracle, unless you really need cased names for some reason, don't use them. They just add an opportunity for error.

bonne chance!

<rx_at_wo.cz> wrote in message news:a50s5d$3p6o1$1_at_ID-123390.news.dfncis.de...
> try:
>
> create table tmp01 ("neco_lower" number);
>
>
>
> "Wilfrid Ertaud" <ertaud.w_at_jcfgroup.com> píše v diskusním příspěvku
> news:a50rac$ll9$1_at_reader1.imaginet.fr...
> > Hello,
> >
> > I am new in the Oracle community and discovering Oracle. Every column I
> > create is in upper case lettering . Is there a way to have them lower
> case.
> > Of course the caps lock key was off!
> >
> > Thanks in advance for your precious help
> >
> > Wilfrid from France
> >
> >
>
>
Received on Wed Feb 20 2002 - 14:07:47 CST