Table Name / Field Case

Hello,

I currently have a little problem with our Oracle8i database. After creating a table with "create table test (id number);". Using this statement will create the table as uppercase. Unfortunately, a client program that has to be migrated to oracle queries the database using quotes: select * from "test"; Oracle will now tell the client that this table does not exist, as the Oracle database will now think that we are looking for a table with "test" in lower case. Is there any way to tell an Oracle database to use lower cases as a default for storing table and field names?

Thank you for your help,

Regards, Christian Ehlers Received on Wed Jul 04 2001 - 04:14:14 CDT