How to execute SQL Query in Squirrel on Oracle Database server?
Joined: Aug 11, 2000
I posted this on the squirrel mailing list yesterday and since I have not received a response, I thought I would try here too.
I'm running squirrel 3.4.0 and oracle database 11g.
I can now connect to my oracle database in my linux guest and I see a nice display of tabs. Previously I had a bad syntax for my connection string and was not connecting. Here is my connection string for squirrel:
The first thing to try is the SQL editor view in Squirrel. If the query works there, it will confirm you have access to that table. You probably do since it works from your Java program, but it is a good thing to confirm.
Next, is "siegfried" the schema owner for those tables? The way to tell is to run
If these don't run, the problem is likely that you are only looking at tables from the "current owner" in Squirrel and need to look for an all users type menu option.