oracle 什么是 PL/SQL 开发的完美工具箱？

What is the perfect toolbox for PL/SQL development?

提问by Romain Linsolas

I work on two projects with a lot of PL/SQL code since few months.

几个月以来，我参与了两个包含大量 PL/SQL 代码的项目。

However, I didn't find any really interesting tools to develop on this langage.

然而，我没有找到任何真正有趣的工具来开发这种语言。

For the moment, my configuration includes the following tools:

目前，我的配置包括以下工具：

• Eclipse(the rest of the application is developed in Java), with PL/SQL Editor plugin
• As I really don't like and trust the PL/SQL Editor plugin for Eclipse, I use mainly PsPadfor editing my PL/SQL files.
• SQL Developer(I have also TOAD, but I don't really know/like this tool).

• Eclipse（应用程序的其余部分是用 Java 开发的），带有PL/SQL Editor 插件
• 因为我真的不喜欢也不信任 Eclipse 的 PL/SQL 编辑器插件，所以我主要使用PsPad来编辑我的 PL/SQL 文件。
• SQL Developer（我也有 TOAD，但我并不真正了解/喜欢这个工具）。

So what is your "perfect" toolbox for developing PL/SQL applications?

那么，您开发 PL/SQL 应用程序的“完美”工具箱是什么？

I've also read that SQL Developer 2.1 introduces a PL/SQL unit testing feature. Does anybody has a feedback about this feature and this version of SQL Developer (I still use 1.5) ?

我还读到 SQL Developer 2.1 引入了 PL/SQL 单元测试功能。有没有人对这个功能和这个版本的 SQL Developer 有反馈（我仍然使用 1.5）？

回答by APC

Being an old-fashioned sort of chap I still mainly get along with SQL*Plus and the TextPad IDE. TextPad is nagware, but the licence is cheap and the tool has some fantastic features. Also people have written PLSQL syntax libraries for it, which give you keyword highlighting. It is also possible to hook TextPad into other desktop tools such as Subversion.

作为一个老式的家伙，我仍然主要与 SQL*Plus 和TextPad IDE相处。TextPad 是 nagware，但许可证很便宜，而且该工具有一些很棒的功能。人们也为它编写了 PLSQL 语法库，它为您提供关键字突出显示。也可以将 TextPad 连接到其他桌面工具，例如Subversion。

SQL^Developer is written in java, which means it is a voracious consumer of memory. Still there is undoubted merit in having a data browser. Also the upcoming version 2.1 features built-in unit test, which could be very tasty.

SQL^Developer 是用 java 编写的，这意味着它是一个贪婪的内存消费者。拥有数据浏览器仍然有无可置疑的优点。即将推出的 2.1 版还具有内置单元测试功能，这可能非常好吃。

Useful utilities:

有用的工具：

• pldoc:: generate Javadoc-style documentation from the comments in your package spec
• utplplsql:: unit test harness; old but it still works
• QUTO:: another, more sophisticated unit test harness (which I don't use for the same reason I'm still hacking with SQL*Plus and TextPad)
• QGCU:: PL/SQL code generator (previously QNXO)

• pldoc:: 根据包规范中的注释生成 Javadoc 样式的文档
• utplplsql:: 单元测试工具；旧但它仍然有效
• QUTO:: 另一个更复杂的单元测试工具（我不使用它的原因与我仍在使用 SQL*Plus 和 TextPad 进行黑客攻击的原因相同）
• QGCU:: PL/SQL 代码生成器（以前是 QNXO）

In defence of Luddism

为卢德主义辩护

The danger with tools like TOAD and SQL*Developer is that they allow us to execute DML and DDL directly against the database, including editing PL/SQL source. This is fine and dandy and awfully in the spirit of Getting Things Done. Until we need to revert our changes. Or the production DBA demands a script....

TOAD 和 SQL*Developer 等工具的危险在于，它们允许我们直接针对数据库执行 DML 和 DDL，包括编辑 PL/SQL 源代码。这很好，很花哨，而且非常符合“完成任务”的精神。直到我们需要恢复我们的更改。或者生产 DBA 需要一个脚本......

Of course it is possible to use TOAD or SQL Developer in a safe fashion - I know SQL Developer can hook into source control as well - if just requires more self-discipline.

当然，可以以安全的方式使用 TOAD 或 SQL Developer - 我知道 SQL Developer 也可以挂钩到源代码控制中 - 如果只是需要更多的自律。

回答by marc_s

I always liked the PL/SQL Developerby Allround Automations - an excellent, quick and easy to use, and totally affordable tool!

我一直很喜欢Allround Automations的PL/SQL Developer- 一款出色、快速且易于使用且完全负担得起的工具！

For an interactive query shell - much better than SQL*Plus - I used to use "Golden" - a nice and powerful shareware tool, highly recommended.

对于交互式查询外壳——比 SQL*Plus 好得多——我曾经使用“ Golden”——强烈推荐的一个很好的和强大的共享软件工具。

Much better than anything else I ever tried with Oracle.

比我用 Oracle 尝试过的任何其他东西都要好得多。

Marc

马克

回答by Ian Carpenter

Might be a slightly different answer than you were expecting but I feel the Oracle documentationand in particular this book should be essential for any PL/SQL toolbox.

答案可能与您的预期略有不同，但我觉得 Oracle文档，尤其是这本书对于任何 PL/SQL 工具箱都应该是必不可少的。

回答by Erich Kitzmueller

My primary editor for PL/SQL packages is SlickEdit. SlickEdit offers good support for PL/SQL development, though you might miss the direct connection to the database that tools like TOAD or SQLDeveloper offer. On the other hand, working on PL/SQL files (instead of directly working on database objects, like many TOAD users do) is IMO a good practice for any non-trivial project. In addition to SlickEdit, I use a few self-made helper programs, e.g. one that loads source code from the database and creates a source file, and another one that compiles the source and calculates the correct line numbers for errors in a file that contains multible objects, e.g. both package specification and body.

我的 PL/SQL 包的主要编辑器是 SlickEdit。SlickEdit 为 PL/SQL 开发提供了良好的支持，尽管您可能会错过 TOAD 或 SQLDeveloper 等工具提供的与数据库的直接连接。另一方面，处理 PL/SQL 文件（而不是像许多 TOAD 用户那样直接处理数据库对象）是 IMO 对于任何非平凡项目的好习惯。除了 SlickEdit 之外，我还使用了一些自制的帮助程序，例如一个从数据库加载源代码并创建源文件，另一个编译源并计算包含错误的文件中的正确行号多重对象，例如包规范和主体。

For direct database access, I prefer SQLDeveloper, mostly because it's free and works well on Linux.

对于直接访问数据库，我更喜欢 SQLDeveloper，主要是因为它是免费的并且在 Linux 上运行良好。

回答by darreljnz

I use:

我用：

• Eclipse as the IDE
• Toby's PLSQL Editoras the PLSQL Eclipse plugin
• TOAD as the database tool
• utplsql and OUnit as the unit test framework
• Ant as the build tool
• CVS as the source control tool
• pldoc as the documentation tool
• CruiseControl as the continuous integration tool

• Eclipse 作为 IDE
• Toby 的 PLSQL 编辑器作为 PLSQL Eclipse 插件
• TOAD 作为数据库工具
• utplsql 和 OUnit 作为单元测试框架
• Ant 作为构建工具
• CVS 作为源代码控制工具
• pldoc 作为文档工具
• CruiseControl 作为持续集成工具

Toby's PLSQL Editorcan do:

Toby 的 PLSQL 编辑器可以：

• Syntax highlighting
• Code completion
• Load to database
• Header generation
• F3 jump to code

• 语法高亮
• 代码补全
• 加载到数据库
• 标头生成
• F3 跳转到代码