oracle 用于 PL/SQL 开发的 IDE

IDE for Pl/SQL development

提问by yesraaj

Is there any free IDE for Pl/SQL development

是否有用于 Pl/SQL 开发的免费 IDE

回答by Dan Vinton

I use SQL Developerevery day to develop packages. Whilst it's not perfect, it's got some useful features:

我每天都使用SQL Developer来开发包。虽然它并不完美，但它有一些有用的功能：

• Syntax highlighting;
• Autocompletion;
• Debugging (although not of live requests as far as I can tell);
• Simple connection configuration (JDBC-based as well as TNSNAMES);
• ...

• 语法高亮；
• 自动完成；
• 调试（尽管据我所知不是实时请求）；
• 简单的连接配置（基于 JDBC 以及 TNSNAMES）；
• ...

It's also free, unlike the (admittedly better) Toadmentioned previously.

它也是免费的，与前面提到的（公认更好的）Toad不同。

回答by Robert Giesecke

I am using PL/SQL Developerfrom Allround automation, too.

我也在使用Allround 自动化的PL/SQL Developer。

I kinda hate it dearly for all its bugs and that we paid a full year maintenance w/o seeing anything new in that period. But for some rather strange reason it still beats the hell out of all the other outrageously overprized and underfeatured tools for PL/SQL. And I am not talking about Oracle administration, which it can do quite good as well, thx to how fast one can script things in it. Its focus is PL/SQL, not point & click table creation. But than, my Grand Ma could build a tool for managing tables, users, etc. A good code editor is not as easy. g

我有点讨厌它的所有错误，而且我们支付了整整一年的维护费用，而在那段时间里没有看到任何新东西。但是出于某种相当奇怪的原因，它仍然比所有其他被过度高估和功能不足的 PL/SQL 工具击败了地狱。而且我不是在谈论 Oracle 管理，它也可以做得很好，感谢人们在其中编写脚本的速度有多快。它的重点是 PL/SQL，而不是点击表创建。但是，我的奶奶可以构建一个工具来管理表、用户等。一个好的代码编辑器并不那么容易。G

One thing, besides the countless little bugs that face every time is, that it is completely ignorant to the fact, that Oracle has an escape syntax for non-standard identifiers. You can't do much using its GUI with such objects but have to resort to the command window or any other editor to script it yourself.

一件事，除了每次都面临的无数小错误之外，它完全不知道Oracle 对非标准标识符有转义语法这一事实。您不能将其 GUI 与此类对象一起使用，但必须求助于命令窗口或任何其他编辑器来自己编写脚本。

btw, the fact that I still use it and prefer over its alternatives doesn't reflect very well on the market of commercial Oracle IDEs, IMO. I think for writing DB code it is better than anything from any DBMS I have come across so far. It has very little GUI support for stuff, but its different code editors are very capable and productive.

顺便说一句，我仍然使用它并且更喜欢它的替代品这一事实并不能很好地反映商业 Oracle IDE 市场，IMO。我认为编写 DB 代码比我迄今为止遇到的任何 DBMS 中的任何东西都要好。它对东西的 GUI 支持很少，但它的不同代码编辑器非常有能力和生产力。

回答by 1800 INFORMATION

Toadgets reasonable comments from the developers around me that have to work with Oracle. Everyone hates Oracle SQL developer. I have little personal experience.

Toad从我周围必须使用 Oracle 的开发人员那里得到了合理的评论。每个人都讨厌Oracle SQL 开发人员。我个人经验很少。

回答by borjab

I personally like http://www.allroundautomations.nl/plsqldev.html

我个人喜欢http://www.allroundautomations.nl/plsqldev.html

Quite usefull for PL/SQL and Oracle in general. But not free.

通常对 PL/SQL 和 Oracle 非常有用。但不是免费的。

回答by manoj kumar sahoo

SQL Tools is a withdraw PL/SQL IDE that is lightweight and prompt, and it's unconstrained. Although one dimension it's absent is a debugger agree.

SQL Tools 是一款轻量级、快速且不受约束的退出 PL/SQL IDE。虽然它不存在的一个维度是调试器同意。

回答by 1stpoint

I have been using Squirrel SQL for years and like it b/c it's database independent. it does have some limitations but if I need something with more DBA tools I would also use SQL Developer.

我多年来一直在使用 Squirrel SQL，并且喜欢它 b/c，它与数据库无关。它确实有一些限制，但如果我需要更多 DBA 工具，我也会使用 SQL Developer。

回答by Aleksander Adamowski

There's also the open source plugin for NetBeans, named PL/SQL Editor.

还有一个名为PL/SQL Editor 的NetBeans 开源插件。

It's currently (version 2.1) very rudimentary, requires a live database to work on (no offline work with on-disk PL/SQL script sources) and I couldn't get the navigation ("Go To Declaration") to work on my Oracle 10 application.

它目前（版本 2.1）非常初级，需要一个实时数据库才能工作（没有磁盘上 PL/SQL 脚本源的离线工作），我无法在我的 Oracle 上使用导航（“转到声明”） 10 应用。

回答by Sergey Stadnik

SQL Toolsis a free PL/SQL IDE that is lightweight and fast, and it's free. Although one feature it's missing is a debugger support.

SQL Tools是一个免费的 PL/SQL IDE，它轻巧、快速，而且是免费的。尽管它缺少的一个功能是调试器支持。