Re: Table Name / Field Case

try:
create table "test" (id number);

the problem about it is that then
ONLY the select * from "test" works
select * from test fails then

Christian Ehlers wrote:

> 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:22:28 CDT