Re: Newbie: Cant see tables from Client

"cris brady" <cbrady_at_alpinenet.com> wrote:

>Mike Madland <mikemad_at_asymetrix.com> wrote in article
><51k9vi$ci0_at_loki.asymetrix.com>...
>> Are the tables created using mixed lower case? If so, then you need
>> to access them using double quotes, like this:
>>
>> SELECT * FROM "cat_cre"
>>
>> Lower-case table and column names are possible in Oracle, but are a
>> pain in the butt. I suggest you drop all of the tables and start
>> over, making sure that the physical name that ERWIN uses for the
>> tables/columns are all in upper case. Use:
>>
>> DROP TABLE "table_name" CASCADE CONSTRAINTS;
>>
>> to drop the tables.
>>

>Mike,
 

>It turns out that it is a rights problem, I don't have select rights to the
>table (why I don't is another problem). But I'm interested in your comment
>about lower case table and column names being a pain in the but in Oracle.
>Could you expound a little, since lower case naming has been my convention
>for MS SQL Server for several years. What kind of problems does it cause?
 

>- Cris
>--
>=====================================================
>mailto:cbrady_at_alpinenet.com software with altitude!
>http://www.alpinenet.com alpine enterprise, ltd.
> Microsoft Solution Provider
> Microsoft Certified Systems Engineer

Oracle isn't case sensitive if you don't put double quotes around the table/column names, but if you do, then it takes what is between the quotes literally.

For example you can say create table foo (...) and then select * from cat and you will see it as FOO. You can then select * from foo or select * from FOO or select * from Foo and have no problems.

BUT, if you say create table "Foo" and then look at it in the dictionary (select * from cat), you will see it as Foo. Then if you say select * from foo, it won't see the table. You must say select * from "Foo" (typing it exactly as it was done in when you created the table). You can also create a table with spaces in the name as well! [Create table "Foo Bar" (...)]

I've noticed that some Windows products put the quotes around table/column names - MS Access is one example. So I always use uppercase only if I create a table in Access and the export it to Oracle.

-Mike Received on Mon Sep 23 1996 - 00:00:00 CEST