File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Can't access Oracle Schema for query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Can Watch "Can New topic

Can't access Oracle Schema for query

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1130
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

Joined: Dec 20, 2006
Posts: 2565

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.

OCUP UML fundamental and ITIL foundation
Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1130

I always forget this.

Thank you very much.

I agree. Here's the link:
subject: Can't access Oracle Schema for query
It's not a secret anymore!