Can't access Oracle Schema for query

[Mike London]

I have a sales database with a customers table, but when I do a "select * from customers", Oracle tells me the table or view does not exist. Huh?

If I go into SQL*PLUS and connect to sales ("Successful"), then do a SELECT * FROM CAT, I see the tables in the sales database (schema), including the customers table.

The only thing that seems to work is:

select * from "customers" (as an example of one of the tables).

----

What's confusing here is that with other Oracle schemas, the quotes are not required.

This makes JDBC programming much more difficult.

Any ideas how I can get Oracle to let me create queries without the quotes?

Thanks in advance.

-- M

[Jan Cumps]

There seems to be a case sensitivity issue.
If you have created your table with a lowercase name (e.g. by using create table "customer" in stead of create table customer), then your sql statement becomes case sensitive, and you will have to provide the query with the table name in the correct case, surrounded by quotes.

[Mike London]

Excellent!

I always forget this.

Thank you very much.