Re: Column names

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Tue, 08 Jun 1999 15:52:13 GMT
Message-ID: <375D3D66.389EBA33@sympatico.ca>

Not completly true.....

Try the following :

SQL> create table test (

  2  "a"            number not null,
  3  A              number not null

  4 );

Table created.

SQL> desc test

 Name                            Null?    Type
 ------------------------------- -------- ----
 a                               NOT NULL NUMBER
 A                               NOT NULL NUMBER

SQL> Then, it's a pain to manipulate the info but as you can clearly see, Oracle will create columns name in mixed mode if you tell him to do it.

Ugly.....

Marc

tedchyn_at_yahoo.com wrote:

> torben, by default oracle table name are upper case whether or not
> your ddl use upper or lower case.
> Ted
> In article <7jj1b3$ahj$1_at_news.inet.tele.dk>,
> "Torben Nyman Nielsen" <torben.nyman_at_kp-c.dk> wrote:
> > Hi all,
> >
> > I have several tables unloaded from ACCESS. Unfortunately the column
> names
> > is in lower case when they are inserted in Oracle 8. Is there a way to
> > convert the column names in a table to UPPER case ???
> >
> > Best regards
> > Torben Nyman Nielsen
> > Allise - Denmark
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jun 08 1999 - 10:52:13 CDT