Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Table Name / Field Case
create a view or public synonym for the table
Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com> ñîîáùèë â íîâîñòÿõ
ñëåäóþùåå:3B42FC31.7C037F70_at_hollomey.com...
> 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:30:45 CDT