Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11 upper case table and field names

user8609285May 31 2011 — edited May 31 2011
I would like to know if it's possible to force the database server (Oracle 11 in this case) to use lower case for table and field names, instead of upper case.

My database is converted from MS-SQL where I am using lower case names. The scripts generated by SQL Developer contain lower-case names. When I execute the scripts to create the database on my Oracle Server, the names are displayed in upper case.

I read elsewhere that I can for the case by enclosing the names with " chacracters, but that would mean laboriously modifying automatically generated scripts, which would seriously reduce the flexibility of the migration.

The reason for doing this is I want to generate an entity relationship model for the MS database, and one for the Oracle version, and use the models interchangeably without modifying my code.
The models, however, are case sensitive. I can only use them flexibly if the table and field names have the same (i.e. lower) case. (I could change the MS database to all upper case, but that would mean much extra work changing queries used in other parts of the system, so it's not an interesting option)

Thanks in advance for any help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2011
Added on May 31 2011
6 comments
1,268 views