SQL Developer 1.5 on Ubuntu Linux
posted by Jake on
Since my work recently relieved us of our Toad licenses, I've gotten to know and love SQL Developer. I used it back in the day of pre-version 1.0 Raptor days, but have recently picked it back up of necessity. I like it for the most part and use it with pleasure for the most part.
Since my work recently relieved us of our Toad licenses, I've gotten to know and love SQL Developer. I used it back in the day of pre-version 1.0 Raptor days, but have recently picked it back up of necessity. I like it for the most part and use it with pleasure for the most part.
I just recently installed Ubuntu 8 on my machine, and threw down this bad boy of a SQL console. I downloaded the tar file for SQL Developer 1.5.
After downloading, unpack the tar
tar xvf sqldeveloper1.5.tar
I copied the directory into /usr/lib:
cp sqldeveloper1.5/ /usr/lib/sqldeveloper1.5
and then added it to the path:
emacs /etc/environment PATH="[other stuff]:/usr/lib/sqldeveloper1.5"
Save and reload env with:
source /etc/environment
(environment is loaded on session login, but this command will refresh it for the current terminal process)
Now, run it from anywhere (it's in your path)
sqldeveloper.sh
1.5 is still in beta, and there still are problems. For one, the column tab for views shows nothing. Pook! Another annoying thing about SQL Developer in general is that you can't specify a default schema. At work, we have developer login schemas, but I want to work within our app schema every time. I wish I could just default to that schema as a per-connection configuration.
I do like the 1.5 version more than 1.2 if nothing, for no more than one changed feature: code complete matches case on the rest of my query (which is lowercase in my case), instead of always giving caps. BTW, the code complete is very nice and responsive.
It was also very good to find a certain FAQ that helped me figure out where to put my tnsnames.ora file. For Linux, it's:
/etc/tnsnames.ora
Also, be sure that tnsnames.ora is available to whatever user you're executing SQL Developer with.
sudo chmod +r /etc/tnsnames.ora
Happy SQL'ing!