oracle 用于 PL/SQL 开发的免费软件工具
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1648825/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Freeware tool for PL/SQL development
提问by Thorsten
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 stored procedures, functions and packages, and need decent debugging capabilities (breakpoints, variable inspection etc.).
我目前正在寻找一个好的（免费）工具来在 Windows 上针对 Oracle XE 数据库进行一些 PL/SQL 开发。我希望开发一些存储过程、函数和包，并且需要不错的调试功能（断点、变量检查等）。
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?
对于数据库的 SQL 方面，我一直在使用 TOADfree 工具，它似乎在调试方面有一些限制。还有哪些其他选择？
回答by zendar
Quote from SQL Developer Site:
引用自 SQL 开发人员站点：
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.
Oracle SQL Developer 是一个用于数据库开发的免费图形工具。使用 SQL Developer，您可以浏览数据库对象、运行 SQL 语句和 SQL 脚本，以及编辑和调试 PL/SQL 语句。
回答by Sergey Stadnik
I find Oracle SQL Developer very frustrating to use. It is slow and non-intuitive. If you don't need PL/SQL Debugging, try SQLToolsor SQLTools++. The latter is a branch of the former with some 10g-specific features. You may also want to check out jOra Eclipse plugin.
我发现 Oracle SQL Developer 使用起来非常令人沮丧。它缓慢且不直观。如果您不需要 PL/SQL 调试，请尝试SQLTools或SQLTools++。后者是前者的一个分支，具有一些 10g 特定的功能。您可能还想查看jOra Eclipse 插件。
回答by ArifMustafa
Agreed with Sergey Stadnik, I also find using Oracle SQL Developer is very frustrating and feel like it is slow and non-intuitive also.
同意 Sergey Stadnik，我也发现使用 Oracle SQL Developer 非常令人沮丧，并且感觉它也很慢且不直观。
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.
另一方面，我使用 Quest Toad 并且由于与视图窗格、工具栏和按钮捆绑在一起的繁重 GUI 感觉一团糟，而且 PL/SQL 编辑器中使用的字体对用户不友好和可怕。
If your are using Windows I am telling you two tools, one without PL/SQLand the kingof its kind.
如果您使用的是Windows我告诉你两个工具，一个没有PL / SQL和国王的同类。
Intellij DataGripin payable versionand to learn download trial one.
的IntelliJ DataGrip在应付版本，并学习下载试用之一。
on other hand with PL/SQL editor and executablefeatures and also available in express edition.
另一方面，具有PL/SQL 编辑器和可执行功能，也可在express 版本中使用。
dbForge Studiofor mostly big gun rdbms engines with limited but full fill most of your requirements.
dbForge Studio适用于大多数大枪 rdbms 引擎，具有有限但完全满足您的大部分要求。
I'm sure by trying these, someone will be a fan!
我相信通过尝试这些，有人会成为粉丝！
回答by marc_s
I always really liked using the PL/SQL Developerfor my stored proc / funcs / trigger work - not free, but not expensive either, and totally worth it!
我一直很喜欢将PL/SQL Developer用于我的存储 proc/funcs/trigger 工作 - 不是免费的，但也不贵，而且完全值得！
For interacting with Oracle, I used various of the Benthic Software's Golden Toolswhich again aren't free, but not expensive at all and worth every penny; they make life with Oracle just that much easier!
为了与 Oracle 交互，我使用了各种 Benthic Software 的Golden Tools，它们同样不是免费的，但一点也不贵，而且物有所值；他们让 Oracle 的生活变得更加轻松！
Marc
马克
