oracle PL/SQL Developer 替代方案
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3574167/
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
PL/SQL Developer alternative
提问by Stephan Schielke
We have a lot of our business logic in an oracle database. So we use a lot of PL/SQLcode. We build, test, and debug PL/SQL packages, procedures, triggers, and functions. Our current tool is the PL/SQL Developer (http://www.allroundautomations.com/).
我们在 oracle 数据库中有很多业务逻辑。所以我们使用了大量的PL/SQL代码。我们构建、测试和调试 PL/SQL 包、过程、触发器和函数。我们当前的工具是 PL/SQL Developer ( http://www.allroundautomations.com/)。
What are your tools for PL/SQL coding and why do you prefer it to the PL/SQL Developer? Or would you prefer to work with PL/SQL Developer?
你的 PL/SQL 编码工具是什么？为什么你更喜欢它而不是 PL/SQL Developer？或者您更愿意与 PL/SQL Developer 一起工作？
There are some alternatives I know (but have no experience):
我知道有一些替代方案（但没有经验）：
- Oracle SQL Developer
- Toad for Oracle
- TOra
- SQuirreL SQL
- Oracle SQL 开发人员
- 甲骨文蟾蜍
- 托拉
- SQuirreL SQL
回答by Kirill Leontev
I say, keep using the tool you currently feel comfortable with. My primary tool is pl/sql developer, which I started with, and which I've been using for years, but I also tried both TOAD and Oracle SQL developer. They both have some of their unique and very nice features, and both miss some of pl/sql developer features, that are crucial for me. So, as long as none of these IDEs appeared to be ultimate for me, I came to a conclusion that switching to a new IDE while I feel ok with developer is nothing but a whim. :)
我说，继续使用你目前感觉舒服的工具。我的主要工具是 pl/sql developer，我开始使用它，并且我已经使用了多年，但我也尝试了 TOAD 和 Oracle SQL developer。它们都有一些独特且非常好的功能，但都缺少一些对我来说至关重要的 pl/sql 开发人员功能。所以，只要这些 IDE 对我来说都不是终极的，我得出的结论是，在我对开发人员感觉良好的情况下切换到新的 IDE 只是一时兴起。:)
回答by user158017
I use Oracle SQL Developer, and it is decent, but it's free - and you get what you pay for. There are a few irritating features (such as the ability to create documents of any type but the inability to see them to then open them) and it sometimes seems a bit slow. It seems to be more designed as a GUI for script writing than a full debugging IDE - although the features are there they are a little clunky. On the whole, it meets my needs, though - and the price is right. And my opinion is that is will keep getting better as it is used by more people.
我使用 Oracle SQL Developer，它很不错，但它是免费的 - 一分钱一分货。有一些令人讨厌的功能（例如能够创建任何类型的文档，但无法看到它们然后打开它们），有时看起来有点慢。它似乎更像是一个用于脚本编写的 GUI，而不是一个完整的调试 IDE——尽管功能在那里，但它们有点笨拙。总的来说，它满足了我的需求——而且价格合适。我的观点是，随着更多人使用它，它会变得越来越好。
If free is not a requirement, I have heard great things about both Toad and PL/SQL.
如果免费不是必需的，我已经听说了有关 Toad 和 PL/SQL 的好消息。
回答by WaldiMen
I have been used Toad for many years and it my opinion it is the best tool for Oracle, but I use it for many other tasks besides PL\SQL development but the price is rather high.
我用Toad很多年了，我认为它是Oracle最好的工具，但除了PL\SQL开发之外，我还用它做许多其他任务，但价格相当高。
Although, in my company some developers uses Oracle SQL Developer only for PL/SQL and they are quite happy with it.
不过，在我的公司中，一些开发人员仅将 Oracle SQL Developer 用于 PL/SQL，他们对此非常满意。
回答by darreljnz
You could try Eclipse with the plugin "Toby's PLSQL Editor". Gives you most of the normal functions like syntax highlighting, code completion and F3 to jump to code. It relies upon your source organised into directories that roughly correspond to schemas.
您可以使用插件“Toby's PLSQL Editor”尝试 Eclipse。为您提供大部分常规功能，如语法高亮、代码完成和 F3 跳转到代码。它依赖于组织到大致对应于模式的目录中的源。
回答by JulesLt
Personally, we use TOAD, but I would say it is inertia as much as anything else (i.e. we've always used it).
就个人而言，我们使用 TOAD，但我会说它和其他任何东西一样都是惯性（即我们一直在使用它）。
Stepping from TOAD to SQL Developer, I prefer TOAD for most things, even though SQL Developer seems less buggy - but that may be familiarity.
从 TOAD 过渡到 SQL Developer，我更喜欢 TOAD 来处理大多数事情，尽管 SQL Developer 看起来不那么容易出错——但这可能是熟悉的。
I'm not sure whether I would pay the price for TOAD if we did not already have licenses.
如果我们还没有许可证，我不确定我是否会为 TOAD 付出代价。
However, I will say that I do most of my actual PL/SQL coding (as opposed to testing/debugging) using e-editor (a Windows equivalent to Textmate) because as a code editor I find TOAD (and SQL Developer) to be pretty limited. They feel a decade behind other language IDEs (Eclipse, XCode, etc). Just the ability to have simple auto-complete speeds me up dramatically.
但是，我会说我使用电子编辑器（与 Textmate 等效的 Windows）完成了大部分实际的 PL/SQL 编码（而不是测试/调试），因为作为代码编辑器，我发现 TOAD（和 SQL Developer）是相当有限。他们感觉比其他语言的 IDE（Eclipse、XCode 等）落后十年。仅具有简单的自动完成功能的能力就会大大加快我的速度。
回答by Ollie
I use both SQL Developer and SQL Navigator.
我同时使用 SQL Developer 和 SQL Navigator。
SQL Developer is good for a free tool but lacks some of the finesse and "nice to haves" that SQL Navigator has but you have to pay for SQL Navigator.
SQL Developer 是一款不错的免费工具，但缺乏 SQL Navigator 所具有的一些技巧和“可有可无”，但您必须为 SQL Navigator 付费。
A lot of IDE choice comes down to personal preference and what you are used to using.
许多 IDE 选择归结为个人喜好和您习惯使用的内容。
I have used TOAD in the past and was more than happy with it, often I do not have much choice which IDE I use as I work on client sites and have to use whichever IDE is standard for them on their equipment.
我过去使用过 TOAD 并且对它非常满意，当我在客户端站点上工作时，我通常没有太多选择使用哪种 IDE，并且必须在他们的设备上使用任何标准的 IDE。
For the record, I have found SQL Developer to be a little slow at times when typing queries etc. but that might just be the PC I'm currently using....
作为记录，我发现 SQL Developer 在键入查询等时有时会有点慢，但这可能只是我目前使用的 PC....
回答by Patrick Szalapski
There is JetBrains 0xDBE, but it is only in beta and may not be very mature yet.
有 JetBrains 0xDBE，但它只是测试版，可能还不是很成熟。
