Free desktop client for Oracle?

database oracle desktop-application
pugmarx picture pugmarx · May 4, 2009 · Viewed 58k times · Source

Which is the best Open Source free client for querying an Oracle database? It may additionally support other databases (MySQL, Postgres etc), since our development environment often requires switching between different databases.

Answer

Peter Perháč picture Peter Perháč · May 4, 2009

I have been using the Oracle SQL Developer (because it's free) and at first hated every minute spent with it. I am still having weird problems with graphics, as it's running on Vista and there seems to be some sort of graphics driver problem (luckily, no-one can get it to run properly on Vista, so I am not alone in this), which makes its use quite cumbersome.

Nevertheless I had to learn how to cope with it and now I must admit it's a neat and very useful tool (NOT ONLY) for querying an Oracle database. I suppose you could query other DBs from it as well, for instance I have used it to query some legacy MS Access DBs, and so I believe you could query SQL Server as well.

You can do data migrations, imports/exports, see OWA output, and allegedly also DEBUG (step through, set breakpoints, etc...) PL/SQL code, but I haven't tried this. I have been fine with sqlplus command-line so far :) Do give it a try, and don't let the Vista-related graphics problems give you a wrong impression :)

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
How can I get column names from a table in Oracle?

I need to query the database to get the column names, not to be confused with data in the table. For example, if I have a table named EVENT_LOG that contains eventID, eventType, eventDesc, and eventTime, then I would …

Read More