Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*PLUS not recognizing table with _
Thanks David
Yes, Lothar gave me the answer but I missed it because his previous
statement about
Select from User_tables did not give me all lower letters.
Well, I guess I have to read any future reply very careful.
Thanks
Mo
David Fitzjarrell wrote:
> 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/
Received on Tue Jan 23 2001 - 20:37:51 CST