File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "Can Watch "Can New topic
Author

Can't access Oracle Schema for query

Mike London
Ranch Hand

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

Joined: Dec 20, 2006
Posts: 2516
    
  10

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
youtube channel
Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1083
Excellent!

I always forget this.

Thank you very much.

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can't access Oracle Schema for query