Oracle SQLDeveloper

 I've been fiddling with Oracle SQLDeveloper lately. What I liked about it is that it's free and second, it's an alternantive to M$ SQLServer. I think you could even use it for other RDBMS other than Oracle like MySQL and SQLServer. It's made in Java(rocks!), and there's an online tutorial on how to use it.

I didn't like PHPMyAdmin that much so if it's indeed possible to use this with other Database systems then I would defintely choose this app. One of the few notable features is its ability to export your data to several file formats like CSV, HTML, XML, etc. although I don't know if you could also do that with SQLServer Management Studio or PHPMyAdmin.

There's also a query builder(like in SQLServer) which allows you to drag tables and dynamically build a query based on the fields you choose and relationships you form. 

I'm doing this in-sync with learning PL/SQL so this is just another great addition in my toolset. 

Published 01-10-2008 6:27 PM by lamia
Filed under:

Comments

Thursday, January 10, 2008 7:47 PM by marl

# re: Oracle SQLDeveloper

if you can get the Toad for Oracle (with Knowledge Xpert), it's a lot better than the SQL Developer. If you need help on the administration side, just let me know.

Thursday, January 10, 2008 8:56 PM by lamia

# re: Oracle SQLDeveloper

Hi marl

Thanks! Yeah, I almost forgot that TOAD is quite a popular tool for Oracle. I first saw it during my internship and visit to one  of the companies I applied internship for. I've looked at the features for the latest version

www.toadsoft.com/feats.html

Unfortunately, I don't have the option of choosing TOAD over SQLDeveloper because it's not installed on our Virtual Server. I could try downloading it though and see if it works with Oracle XE.

Sunday, January 20, 2008 9:07 PM by Charles

# re: Oracle SQLDeveloper

I like SQLDeveloper better than Toad due to its portability. You can carry the application on a flash disk, no need to install. Futhermore, TOAD requires that Oracle client to work, SQLDeveloper doesn't.

You should also note that the freeware version of TOAD is really underpowered...