Mo’s Corner

My corner

Replace toad with Oracle SQL Developer

Mo J. Al-Mughrabi under it

If you are working with Oracle applications databases at work or even during your studies you will know something for sure, dealing with SQL*Plus is a nightmare and sooner you will realize its not a productive tool for developers nor administrators. So, most developers use TOAD which is incredibly smart, easy to use and double your productivity with exports option, history, table structure views and much more. Today, I tried googling for the oracle tools and I stumbled upon this new Oracle SQL Developer which was released sometime during this year. 

I've been using it all day in the morning and it is very interesting. first of all, its FREE and you can do exactly the things you can do with a TOAD only that with Oracle SQL Developer you are using Oracle product! I noticed though it retrieves data a but slower than TOAD but I assume it was something to do with me using a virtual machine at that moment. The beautiful part, it is a cross platform in the sense you can run it on your windows, mac or even linux desktop as long as you have java runtime environment. 

« Eating live fishes in Shanghai
Tomb of the Dragon Emperor really sucked »
  1. Emad.N Said,

    thanks a lot for your note

  2. حمود راعي السيكل Said,

    I’ve used it before, the commercial version, but since i belong to an old school (*) , i prefer Oracle in pure vanilla flavor :)

    That doesn’t mean Toad is bad, it is indeed a very useful tool, actually all Quest products are great.

    (*) Do you recall Oracle 7 & 8 (without the stupid Java and the “i”?

    Thanks

  3. Bojacob Said,

    Was just about to complain for no reason since I love the free MySQL, but I saw TOAD supports MySQL as well! I gotta give it a look.

  4. Mo J. Al-Mughrabi Said,

    BoJacob, I tried using Toad for MySQL but its not very stable specially when you are returning massive queries, the best thing about is that you can connect remotely to a machine through SSH and from SSH its will open a mysql-client session, This is extremely useful when your database administrator is blocking direct access to the database. For MySQL I usually use MySQL Query Browser, not very superb but you can do exporting into sheets and its quite fast when querying remote databases.

    Hamoud, I didn’t catch up on Oracle 7 nor 8 my experience started with 9i and Java is not stupid :P lol

  5. حمود راعي السيكل Said,

    bojacob,

    you could give “EMS SQL manager for MySQL” a try, i don’t know about the MySQL version, but the Oracle one is great

    http://www.sqlmanager.net/en/products/studio/mysql

    Mo,

    yours started at 9i, and mine stopped at 8 , it looks to me similar to an Olympic torch! :)

    I still remember those days i used to be and Oracle DBA (not a developer, i hate them like the Java thing) lool :)

    i don’t work with computers anymore.

  6. Ali Said,

    Thank you for sharing this knowledge.

Add A Comment

Subscribe to Mo’s Corner