Hello is there any Oracle database ( around version 10 ) front end that we can use in Linux. free or open source?
I am currently using Ubuntu 8.10 and if possible I just want it to need the thin JDBC to connect to oracle and not the whole ( huge ) client of oracle installed in it.
Thanks !
I use Oracle SQL Developer which is similar to TOAD (which is not free). SQL Developer is free and supported by Oracle. Make sure you get the latest version as they're improving it all the time. It has a nice graphical UI and support for editing PL/SQL stored procedures. I think there are even plugins for other databases (like MySQL).
Its a Java application and there is a Linux distribution, though I use the Windows version. It does not require an Oracle client, though it does support one, like the Oracle Instant Client, should you have it installed.
seems like http://tora.sourceforge.net/ is the opensource version of toad
also there is http://oss.oracle.com/sqldeveloper.html
Pretty much any JDBC tool will be able to talk compentantly to Oracle.
I've used SQuirrel SQL Client, SQL Workbench, DbVisualizer (free edition). There's even plug-ins for jEdit that can talk to a database.