This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Can't access Oracle Schema for query

 
Mike London
Ranch Hand
Posts: 1290
6
  • 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: 2618
14
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: 1290
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Excellent!

I always forget this.

Thank you very much.

 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!