Oracle SQL GUI editor for Windows / Linux / Mac

Before you go crazy trying to configure Tora or Toad or other SQL editors for Linux, try this nice (as in free) SQL editor for Oracle (Windows/Linux/Mac):http://www.oracle.com/technology/software/products/sql/index.html

Installation notes for Ubuntu (i'm nOOb on Linux, but this worked for me):1. Make sure you have the "alien" package installed on your pc

Codice:

sudo apt-get install alien

2. After you finish downloading the sqldeveloper-*.rpm file transform it into a .deb by typing

Codice:

sudo alien --script sqldeveloper-*.rpm

3. Install the newly created .deb file:

Codice:

sudo dpkg -i sqldeveloper_*.deb

That should do it! You now have a nice icon in the Programming menu.If you click it and nothing happens open a console and type

Codice:

sqldeveloper

. If it's asking for the homepath of your JDK installation do the following:1. Locate the installation folder of your SqlDeveloper (should be /home/userName/.sqldeveloper/ but in my case was /opt/sqldeveloper/ so check there too).2. In the file /sqldeveloperInstallationFolder/sqldeveloper/bin/sqldeveloper.conf add SetJavaHome /usr/lib/jvm/java-6-sun-*