我说，继续使用你目前觉得舒服的工具。我的主要工具是 pl/sql Developer，我从它开始使用，并且已经使用了很多年，但我也尝试过 TOAD 和 Oracle SQL Developer。它们都有一些独特且非常好的功能，并且都缺少一些 pl/sql 开发人员功能，这对我来说至关重要。因此，只要这些 IDE 对我来说都不是终极的，我就得出结论：在我对开发人员感到满意的情况下切换到新的 IDE 只不过是一时兴起。 :)
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. :)
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.
Although, in my company some developers uses Oracle SQL Developer only for PL/SQL and they are quite happy with it.
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.
If free is not a requirement, I have heard great things about both Toad and PL/SQL.
Personally, we use TOAD, but I would say it is inertia as much as anything else (i.e. we've always used it).
Stepping from TOAD to SQL Developer, I prefer TOAD for most things, even though SQL Developer seems less buggy - but that may be familiarity.
I'm not sure whether I would pay the price for TOAD if we did not already have licenses.
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.
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.
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.
A lot of IDE choice comes down to personal preference and what you are used to using.
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.
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....
发布评论
评论（7）
我说，继续使用你目前觉得舒服的工具。我的主要工具是 pl/sql Developer，我从它开始使用，并且已经使用了很多年，但我也尝试过 TOAD 和 Oracle SQL Developer。它们都有一些独特且非常好的功能，并且都缺少一些 pl/sql 开发人员功能，这对我来说至关重要。因此，只要这些 IDE 对我来说都不是终极的，我就得出结论：在我对开发人员感到满意的情况下切换到新的 IDE 只不过是一时兴起。 :)
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. :)
我已经使用Toad很多年了，我认为它是Oracle最好的工具，但除了PL\SQL开发之外，我还用它完成许多其他任务，但价格相当高。
尽管如此，在我的公司中，一些开发人员仅将 Oracle SQL Developer 用于 PL/SQL，并且他们对此非常满意。
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.
Although, in my company some developers uses Oracle SQL Developer only for PL/SQL and they are quite happy with it.
我使用 Oracle SQL Developer，它很不错，但它是免费的 - 一分钱一分货。有一些令人恼火的功能（例如能够创建任何类型的文档，但无法查看它们然后打开它们），并且有时看起来有点慢。它似乎更像是一个用于脚本编写的 GUI，而不是一个完整的调试 IDE——尽管功能已经有了，但有点笨重。总的来说，它满足了我的需求，而且价格也合适。我的观点是，随着更多人使用它，它会变得越来越好。
如果免费不是必需的，我听说过 Toad 和 PL/SQL 的伟大之处。
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.
If free is not a requirement, I have heard great things about both Toad and PL/SQL.
就我个人而言，我们使用 TOAD，但我想说它和其他任何东西一样都是惯性（即我们一直使用它）。
从 TOAD 到 SQL Developer，我在大多数事情上更喜欢 TOAD，尽管 SQL Developer 看起来 bug 较少 - 但这可能是熟悉的。
如果我们还没有许可证，我不确定是否愿意为 TOAD 支付价格。
不过，我会说，我大部分实际的 PL/SQL 编码（而不是测试/调试）都是使用电子编辑器（相当于 Textmate 的 Windows）进行的，因为作为代码编辑器，我发现 TOAD（和 SQL Developer）相当有限。他们感觉比其他语言 IDE（Eclipse、XCode 等）落后了十年。仅仅简单的自动完成功能就可以大大加快我的速度。
Personally, we use TOAD, but I would say it is inertia as much as anything else (i.e. we've always used it).
Stepping from TOAD to SQL Developer, I prefer TOAD for most things, even though SQL Developer seems less buggy - but that may be familiarity.
I'm not sure whether I would pay the price for TOAD if we did not already have licenses.
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.
您可以尝试使用 Eclipse 插件“Toby's PLSQL Editor”。为您提供大多数常规功能，例如语法突出显示、代码完成和 F3 跳转到代码。它依赖于组织成大致对应于架构的目录的源代码。
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.
我同时使用 SQL Developer 和 SQL Navigator。
SQL Developer 是一款很好的免费工具，但缺乏 SQL Navigator 所具有的一些技巧和“好东西”，但您必须为 SQL Navigator 付费。
许多 IDE 选择取决于个人喜好和您习惯使用的内容。
我过去使用过 TOAD，并且对它非常满意，当我在客户端站点上工作时，我通常没有太多选择使用哪个 IDE，并且必须使用他们设备上标准的 IDE。
根据记录，我发现 SQL Developer 在键入查询等时有时有点慢，但这可能只是我当前使用的 PC...
I use both SQL Developer and 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.
A lot of IDE choice comes down to personal preference and what you are used to using.
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.
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....
有 JetBrains 0xDBE，但它还只是测试版，可能还不是很成熟。
There is JetBrains 0xDBE, but it is only in beta and may not be very mature yet.