SQL Developer is another tool that I have found very helpful. I have been toying with my own SQL Access tool, but SQL Developer is much more full featured.
Update: I have a new post with notes for installing SQL Developer 4.0 on Ubuntu 13:10 — Fixing SQL Developer 4.0.
Here’s how I installed it:
You can easily download it from Oracle’s SQL Developer Download Page. Just make sure that you pick the correct version for your OS. Ubuntu does not use RPM packages, so you will have to download the zip file.
First, you simply need to extract the zip file. I like to place it in my ~/bin directory. You can either use the unzip command or double click on the zip file and open it with file roller.
You have to make the launch script executable. You can use chmod ($chmod +x sqldeveloper.sh), or you can right click on the file and edit the properties.
You will have to run the program from the command line the first time because you will have to choose a JVM. It will prompt you to type the path to your Java installation.
You can see what JVMs you have installed by looking in the /usr/lib/jvm/ directory. I believe that you want to select a 1.6 version. It complains about Java 7.
Creating the Shortcut in the Menu
To make launching the program easier, you will want to add it to the Main Menu program. So, launch Main Menu. I placed it under Programming. Then, click the New Item button.
You will find the sqldeveloper.sh and the icon both in the directory where you unzipped the package you downloaded.