Re: Re: SQL*PLUS not recognizing table with _

In our last gripping episode MAbbouchi_at_IITRI.ORG wrote:
> Thank you guys
>
> I confirmed as I thought that _ is not a problem and my second guess
 was
> "Time" in the name
> but that was not a problem either.
>
> Here's what I believe the problem, this table was created using
 Access 2000
> Export wizard,
> Would this cause a problem??
>
> and if a case sensitive table name was created, how I can work around
 it??
> typing the name
> as case sensitive gives the same error.
>
> Thanks
> Mo
>
> --
> Posted from nat05.IITRI.ORG [205.167.170.5]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
>

You have been given that information in a previous post, but I shall repeat it here:

select ...
from "<case-sensitive tablename>"
where ...

Enclose the case-sensitive tablename in double quotes.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/