The topic of SQL development tools is consistently a hugely popular one both here on the blog and on SearchOracle.com. (See “Oracle unveils free SQL Developer: Has Toad met its match?” and “Oracle SQL Developer vs. Toad: Users speak out” for examples.)
For yet another take on this issue, check out Patrick Wolf’s blog entry titled “What is your favorite PL/SQL development environment?”
Patrick’s is PL/SQL Developer from Allround Automtations. Why does he prefer this editor to Toad or SQL Developer? Because, he says, it’s focused on PL/SQL development. What makes it different from the other tools is “the code complete/code insight/auto complete” capability. While Toad and SQL Developer also have this feature, it’s basic and only works for tables and views, whereas PL/SQL Developer’s equivalent works for local variables, packages, procedures, parameters and so on, a big time-saver.
Patrick concedes that DBAs will probably always prefer Toad/SQL Developer, but he urges PL/SQL developers to try out this tool.
Developers, what are your thoughts on SQL Developer vs. PL/SQL Developer?