Re: mixed case column names

Sameer,

Just wanted to say thanks for your advice regarding my mixed case table and column names. Actually , the culprit was MS Access who generated the tables that way. When I loaded the DDL into Erwin (after dropping all the tables) and regenerated everthing...all was sooper.

It is people like you who take the time out of your schedule to help dummies like me that make the world a better place.

Thanks again,

paul reed

Sameer Mahajan wrote:

> HI Paul,
>
> I guess that ERWin Create script must have something like
>
> Create table "Mixed_Case"
> (
> "Mixed_Case_Field"
> ...
> )
>
> Then Oracle would create the table in the same way i.e. mixed case.
>
> I would suggest u to do a describe on the table u have create under
> SQL*Plus that should tell u whats the exact definition in the Oracle
> database.
>
> To check the table name u could use:
>
> Select table_name from user_tables;
>
> The try doing a
> > describe "Mixed_Case"
>
> If that's the case then remove all the " " from the create script. That
> would convert every thing to upper case irrespective of Mixed_Case.
>
> HTH
>
> Sameer Mahajan
> sameermj_at_usa.net
>
> Paul R. Reed, Jr. <prreed_at_halcyon.com> wrote in article
> <34C108B9.49DDE792_at_halcyon.com>...
> > Hello,
> >
> > I am running Oracle 7.3 on Windows/NT and have a very dumb question to
> > ask. I generated some DDL from ERWin into Oracle and the table names
> > and column names are mixed case. According to my Oracle manual, Oracle
> > treats these names as all upper case.
> >
> > Whenever I execute queries agains my database through ODBC, it requires
> > me to put the table name and column name in double quotes. I went in
> > and created synonyms for the tables without the quotes but I still can't
> > refer to the column names unless I do something like:
> >
> > "tablename"."columnname".
> >
> > This same DDL generated in MS SQLServer works like a champ without all
> > this mishmash...any ideas.
> >
> > Paul
> >
> > --
> > ---------------------------------------------------
> > Jackson-Reed, Inc. Ph 719-598-8615 Fax 719-598-8614
> > "Your Prescription To Client/Server Success"
> > http://www.jacksonreed.com
> >
> >
> >

--
---------------------------------------------------
Jackson-Reed, Inc. Ph 719-598-8615 Fax 719-598-8614
"Your Prescription To Client/Server Success"
http://www.jacksonreed.com