有没有比 Oracle SQL Developer 更好的工具？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10392771/
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
Is there a better tool compared to Oracle SQL Developer?
提问by egervari
I'm just starting to learn Oracle SQL Developer as I develop PL/SQL code at my new job, and while it's an okay tool, it lacks a lot of the conveniences and features that you'd want when writing programs using a different IDE (such as IDEA).
我刚开始在我的新工作中开发 PL/SQL 代码时学习 Oracle SQL Developer，虽然它是一个不错的工具，但它缺乏使用不同 IDE 编写程序时所需的许多便利和特性（例如 IDEA）。
Is there a different tool out there that really assists when building large packages/procedures/functions of PL/SQL code compared to Oracle's SQL developer 3? It would be great to get features like code completion, or to have the ability to CTRL-click a procedure name to quickly jump to a piece of code, and other nice features of this type?
与 Oracle 的 SQL developer 3 相比，是否有其他工具在构建 PL/SQL 代码的大型包/过程/函数时真正有帮助？获得诸如代码完成之类的功能，或者能够通过 CTRL 键单击过程名称以快速跳转到一段代码以及其他此类不错的功能，会很棒吗？
回答by Maddy
PL/SQL Developerby AllroundAutomations its really good one. Provides all the basic features that other tools provides. And very good while debugging your stored procedures, functions and triggers. But it is also a licensed version. There are no. of add-ons are available which makes tool more powerful and You can customize your Plsql developer as shown in following links. hereand here
AllroundAutomations 的PL/SQL Developer真的很好。提供其他工具提供的所有基本功能。在调试存储过程、函数和触发器时非常好。但它也是一个行货版本。没有。可用的附加组件使工具更强大，您可以自定义您的 Plsql 开发人员，如以下链接所示。 这里和这里
回答by C.c
I think Oracle SQL Developer is okay to develop PL/SQL code, It is a free software produced by Oracle org, it might lack of some specific features. but it satisfies most of common usages and functionality.
我认为 Oracle SQL Developer 可以开发 PL/SQL 代码，它是 Oracle 组织生产的免费软件，可能缺少某些特定功能。但它满足大多数常见用法和功能。
Toad is a more powerful tool with very widely used. but you need get a license.
Toad 是一个更强大的工具，使用非常广泛。但你需要获得许可证。
回答by moleboy
PL/SQL developer was interesting to try out a couple years ago, but I'm always finding myself doing a decent amount of DBA type work, and it wasn't very helpful with that. My DBA skills are not particularly strong, so that area, Toad and SQL Developer definitely come out ahead.
几年前尝试 PL/SQL 开发人员很有趣，但我总是发现自己在做大量的 DBA 类型的工作，但这并没有太大帮助。我的DBA 能力不是特别强，所以在这方面，Toad 和SQL Developer 绝对领先。
Overall, I prefer Toad (though it can be a resource hog, and getting everything working the way you want can be a pain). There's different versions (one specifically for developers) so one of those might suit you.
总的来说，我更喜欢 Toad（尽管它可能会占用大量资源，并且让一切以您想要的方式工作可能会很痛苦）。有不同的版本（一个专门针对开发人员），因此其中一个可能适合您。
I recently started a new job, and decided to give SQL Developer a run (this is primarily because Toad is expensive enough that some places won't spend the money on it...like my last job...so it seemed like a good idea to pick a tool I knew I'd have everywhere). It certainly has its issues (it seems to be rather stubborn about breaking a connection if a query is running...but its possible thats a java thing), but it is free, lightweight, and gets the job done.
我最近开始了一份新工作，并决定尝试 SQL Developer（这主要是因为 Toad 足够昂贵，有些地方不会花钱……就像我的上一份工作……所以它看起来像是选择一个我知道我到处都有的工具是个好主意）。它当然有它的问题（如果查询正在运行，它似乎很顽固地断开连接……但它可能是 Java 的东西），但它是免费的、轻量级的，并且可以完成工作。
A note on Toad: At this point (possibly for the forseeable future) is strictly a 32-bit app. It'll run on a 64-bit windows box and connect to a 64-bit Oracle database, but the Oracle client must be 32-bit
关于 Toad 的说明：此时（可能在可预见的未来）是一个严格的 32 位应用程序。它将在 64 位 Windows 机器上运行并连接到 64 位 Oracle 数据库，但 Oracle 客户端必须是 32 位
