Oracle PL/SQL 很好的参考

A good reference for Oracle PL/SQL

提问by David Waters

What are the best references for Oracle PL/SQL? I have an excellent knowlege of SQL-92 and of MS-SQL extensions, but now I'm working with Oracle and I'm struggling to find good references for the PL/SQL language.

Oracle PL/SQL 的最佳参考资料是什么？我对 SQL-92 和 MS-SQL 扩展有很好的了解，但现在我正在使用 Oracle，我正在努力寻找 PL/SQL 语言的良好参考。

I am looking for references for the following:

我正在寻找以下参考资料：

• Variable
• Loops
• Cursor
• Packages
• Trigger
• Stored Procedures
• Temporary Tables

• 多变的
• 循环
• 光标
• 套餐
• 扳机
• 存储过程
• 临时表

Thanks so much.

非常感谢。

回答by APC

As Klaus says the online documentation is pretty good. Start with the 2-Day Application Developer's Guide. If you're using 11gR2, you'll want to read the most recent version of the PL/SQL Language Reference. Newer Oracle releases have updated versions of the documents.

正如克劳斯所说，在线文档非常好。从2 天应用程序开发人员指南 开始。如果您使用 11gR2，您需要阅读最新版本的PL/SQL 语言参考。较新的 Oracle 版本具有文档的更新版本。

But if you want to buy a book, then Steven Feuerstein's Oracle PL/SQL Programmingis the one.

但是如果您想买一本书，那么 Steven Feuerstein 的Oracle PL/SQL Programming就是其中之一。

回答by APC

One additional observation. You include temporary tables in a list of PL/SQL features. This is because you are used to the T-SQL way of doing things. In Oracle things are handled differently.

一个额外的观察。您将临时表包含在 PL/SQL 功能列表中。这是因为您已经习惯了 T-SQL 的做事方式。在 Oracle 中，事情的处理方式不同。

In Oracle we have global temporary tables. These are permanentdatabase objects, like regular tables, but they are defined so that the data is held temporarily - either for the duration of a transaction or a session. The data in a global temporary table is only queryable by the session which populates it.

在 Oracle 中，我们有全局临时表。这些是永久性数据库对象，如常规表，但它们被定义为临时保存数据 - 无论是在事务期间还是会话期间。全局临时表中的数据只能由填充它的会话查询。

The point being that temporary tables are discussed in the SQL Reference, not the PL/SQL manual.

关键是在SQL Reference中讨论了临时表，而不是 PL/SQL 手册。

回答by Tony Andrews

In addition to PL/SQL documentation that others have mentioned, the Oracle Database Concepts Guideis a good reference for finding out how Oracle works, including an overview of package, triggers, tables etc. I have posted a link to the 11.2 version, but you can find the docs for older versions here.

除了其他人提到的 PL/SQL 文档之外，Oracle Database Concepts Guide是了解 Oracle 如何工作的很好参考，包括包、触发器、表等的概述。我已经发布了 11.2 版本的链接，但是您可以在此处找到旧版本的文档。

回答by barker

I've always found Tech on the Netto be good quick reference

我一直发现网络上的技术是很好的快速参考

回答by Klaus Byskov Pedersen

This referenceis really good.

这个参考确实不错。

回答by MeachamRob

Java2s has a good reference tutorial.

Java2s 有很好的参考教程。

Here is the Oracle section: http://www.java2s.com/Book/Oracle/CatalogOracle.htm

这是 Oracle 部分：http: //www.java2s.com/Book/Oracle/CatalogOracle.htm

Here is the Oracle PL/SQL reference catalog, easy to navigate: http://www.java2s.com/Code/Oracle/CatalogOracle.htm

这是 Oracle PL/SQL 参考目录，易于浏览：http: //www.java2s.com/Code/Oracle/CatalogOracle.htm

Here is the Oracle PL/SQL tutorial section: http://www.java2s.com/Tutorial/Oracle/CatalogOracle.htm

这是 Oracle PL/SQL 教程部分：http: //www.java2s.com/Tutorial/Oracle/CatalogOracle.htm

I have the OReilly Book but won't post where I got that link along with Oracle Student workbook which is on Scribd.

我有 OReilly Book，但不会将我获得该链接的位置与 Scribd 上的 Oracle Student 工作簿一起发布。

And along with the Oracle references and tahiti oracle, this site was a good tutorial site for beginners. http://www.tutorialspoint.com/plsql/index.htm

除了 Oracle 参考资料和 tahiti oracle 之外，该站点还是适合初学者的良好教程站点。 http://www.tutorialspoint.com/plsql/index.htm

回答by Sree Rama

Adding points to accepted answer:

为接受的答案添加分数：

• 1)Concepts for Database Developers
• 2) Temporary tables in stored procedure from AskTomSample code snippet from AskTom open ref_cursor for select * from ( query you used to put into temp_1 ), ( query you used to put into temp_2 ) where join_conditions

• 1)数据库开发人员的概念
• 2)来自 AskTom 的存储过程中的临时表来自 AskTom 的示例代码片段打开 ref_cursor for select * from ( query you used to put into temp_1 ), ( query you used to put into temp_2 ) where join_conditions

in your procedure. You'll find that Oracle is much better at complex queries involving dozens (yes more then 16) tables -- without any issues whatsoever.

在你的程序中。您会发现 Oracle 在涉及数十个（是超过 16 个）表的复杂查询方面做得更好——没有任何问题。