• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can't access Oracle Schema for query

 
Mike London
Ranch Hand
Posts: 1190
4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1190
4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Excellent!

I always forget this.

Thank you very much.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic