Oracle 11 upper case table and field names
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!