» VIEW ALL POSTS May 15 2007   12:04PM GMT

SQL Developer vs. PL/SQL Developer



Posted by: Beth Pariseau
Tags:
Oracle database administration
Oracle development

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?

-Elisa

7  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Beth Pariseau
    As the first article says - the price is right on sql developer. I think this, combined with the rapid improvement of the software will enable it to win out in the end. SQL Developer is the best program I have found for Linux - aside from the price, and linux is my preferred platform. The ease of developing extensions is also a big plus. The SQL Developer folks have some catching up to do, but if the last 9 months or so are any indication, they will be a front runner before long.
    0 pointsBadges:
    report
  • Beth Pariseau
    I would truly rate 'PL/SQL Developer' way ahead of TOAD and SQL Developer - for ease of use and as Patrick says it is focussed on PL/SQL development. It also has a clean, uncluttered interface with all the required features which makes is higly appealing. - kannan, NZ
    0 pointsBadges:
    report
  • Beth Pariseau
    Hands down, PL/SQL Developer is the best editor for developers. Toad was designed as a tool for DBAs, but PL/SQL Developer was designed specifically to aid development work. You cannot beat the price or the service from Allround Automations. They have online forums to ask questions, resolve problems and they DO respond to posts, usually within 24 hours. They also offer free plug-ins that add functionality. You can even get a powerful reporting tool, Query Reporter, that offers SQL/HTML reporting - free! You can customize the editor the way it suits you and set preferences for company standards such as indentions and uppercase/lowercase. If my client doesn't have this tool, I bring my copy because I do not want to be without it.
    0 pointsBadges:
    report
  • Beth Pariseau
    If you are serious about SQL and PL/SQL development then Allround Automations' PL/SQL Developer is the tool to have.
    0 pointsBadges:
    report
  • Beth Pariseau
    Hi PL/SQL Developer form Allround Automation is the best tool specially designed for PL/SQL developers. I recommend it highly. It has all the features a professional IDE for Java and C++ has.
    0 pointsBadges:
    report
  • Beth Pariseau
    As a daily user of PL/SQL Developer for the past 18 months I cannot sing its praises loud enough. It has been a highly effective tool during the development of hundreds of pl/sql programs and sql scripts. The program is very reliable, I've experience bugs/crashes very infrequently (
    0 pointsBadges:
    report
  • Beth Pariseau
    I vote for TOAD. It comes with Knowledge Xpert which I think is the best Help file. It is not only good for DBA, but also for developer. Bug tracking is good also. PL/SQL Developer? maybe just 80% of it.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: