Freeware tool for PL/SQL development [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 4 years ago.

Improve this question

I'm currently looking for a good (free) tool to do some PL/SQL development on Windows against an Oracle XE database. I'm looking to develop some st开发者_如何学Pythonored procedures, functions and packages, and need decent debugging capabilities (breakpoints, variable inspection etc.).

For the SQL side of database stuff, I've been using the TOADfree tool, which seems to have some limitations on the debugging side. Which other options are there?

---

Oracle SQL Developer

Quote from SQL Developer Site:

Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements.

---

I find Oracle SQL Developer very frustrating to use. It is slow and non-intuitive. If you don't need PL/SQL Debugging, try SQLTools or SQLTools++. The latter is a branch of the former with some 10g-specific features. You may also want to check out jOra Eclipse plugin.

---

I always really liked using the PL/SQL Developer for my stored proc / funcs / trigger work - not free, but not expensive either, and totally worth it!

For interacting with Oracle, I used various of the Benthic Software's Golden Tools which again aren't free, but not expensive at all and worth every penny; they make life with Oracle just that much easier!

Marc

---

Agreed with Sergey Stadnik, I also find using Oracle SQL Developer is very frustrating and feel like it is slow and non-intuitive also.

On other hand I used Quest Toad and feel like mess due to heavy GUI bundled with view panes, toolbars and buttons also the font used within in PL/SQL editor is not much user friendly and horrible.

If your are using Windows I am telling you two tools, one without PL/SQL and the king of its kind.

Intellij DataGrip in payable version and to learn download trial one.

on other hand with PL/SQL editor and executable features and also available in express edition.

dbForge Studio for mostly big gun rdbms engines with limited but full fill most of your requirements.

I'm sure by trying these, someone will be a fan!