What is your favorite PL/SQL development environment?

Mine is PL/SQL Developer from allroundautomations.


Because it’s a PL/SQL development tool focused on PL/SQL development. Most of the other tools like TOAD or SQL Developer which I also used in the past, have great DBA/query functionality, but suck from a “state of the art” programming point of view.

Sure they all have a PL/SQL editor with auto replace and template support. In the meanwhile SQL Developer is now also able to do file based PL/SQL development. In one of the first versions you could just edit the packages stored in the database repository. Can you imagine doing professional development where your code is just stored in the database?!?! Me not! That was a killer criteria not to use it at that time – independent if it was for free or not.

So what makes PL/SQL developer different compared to TOAD and SQL Developer?

It’s the code complete/code insight/auto complete or however the IDEs call it and which you are used to from modern Java/.Net/… IDEs. Now you will say: “Hey, TOAD and SQL Developer have that too!”. Yes they have, but just a basic one which only offers auto complete for tables/views.

The auto complete I’m talking about knows about the PL/SQL code you wrote. If works for local variables, packages, procedures of the packages, parameters of this procedures, … If you are getting used to to press Alt+space to complete what you are typing, it can really speed up your development!

I’m not talking about the other features like refactoring support, variable highlighting and so on what the tool also offers. Check it out by yourself.

If you are used to TOAD, changing to this new IDE can be a little bit irritating at the beginning, because the way windows are handled is different and you have to get used to the SQL Window which requires a semi-color for SQL statements.

But it’s worth trying out – from a PL/SQL developer point of view – a DBA should stay with his TOAD/SQL Developer.

BTW, I’m not paid for this article. I’m just a satisfied user of that tool and I see to often unproductive PL/SQL development with the wrong tools.

Update: Another useful feature is the integrated compiler which shows you warnings for unused variables/parameters or if the naming doesn’t comply to your styleguide.

10 thoughts on “What is your favorite PL/SQL development environment?

  1. Great to hear there are more people who like PL/SQL developer. I use it since version 4 and I like it better than TOAD. Just because of the fact it is especially written for PL/SQL developers. In the last release it now also has code folding (like in e.g. Visual Studio).
    I sometimes use TOAD, but mainly because of its DBA features.

  2. Don’t knock VI… I use gVim every day for lots of different things!

    But then again… I’m a geek!

  3. Hi Doug,

    I think the most important thing about all this tool discussion is that a user has to be happy with it and should be able to handle and know the features of it.

    Some are keyboard shortcut/command freaks and don’t want to touch the mouse, others do even the copy/paste with the mouse. As long as both are productive and happy, who cares.


  4. Notepad.. VI?

    I always use “copy con script.sql” 😉

    But seriously… I am a long time PL/SQL Developer user and I wouldn’t know how to survive without it.

    Oracle’s SQL Developer is becoming better… sadly you need load’s of resources to run it.

    Toad always manages to confuse me. The interface is not intuitive.

    IMO, Toad is more geared towards the DBA where PL/SQL Developer (as the name suggests) is suited more for developers.

  5. PL/SQL developer is a great tool for PL/SQL Development. I am using this tool from the version 6.0

    I actually recommended this tool in our company for our development work. Even my client, after seeing the advantages, both in terms of Price and Features, bought licenses for their development team.

  6. Couldn’t agree more Patrick – I have been using PL/SQL Developer for well over 6 years now and have found it to be the best Oracle DB development IDE.
    SQK Developer isn’t quite there yet, but is making good progress.

Comments are closed.