Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to access table with lowercase character in oracle 8.0.5
On Sun, 21 May 2000 23:09:08 GMT, "Sihua Luo" <luosh_at_yesic.com> wrote:
>Hi guys,
>
>I got a table with a lowercase table name. Using Access 2.0 (Win98
>environment) to connect to oracle 8.0.5 on unix by ODBC, In Access I
>exported a local table with lowercase table name to ODBC then the lowercase
>table name was exported to Oracle 8.0.5. I can check it is in user_tables,
>all_objects and other dictionary view, but I cannot access that table since
>oracle suppose tablename is uppercase.
>If the local table have a uppercase table name, everything is OK.
>
>My question is how to access the table with lowercase table name?
hmm tried something like
select * from "small_letters" ?
I tried that on columns and it i working
>
>Thank you in advance.
>
>Frank
>
>
>
>
>
Received on Wed May 24 2000 - 00:00:00 CDT