Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: mixed case column names
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
>
>
>
Received on Sun Jan 18 1998 - 00:00:00 CST