Oracle PL/SQL Programming, 6/e (Paperback)

Steven Feuerstein, Bill Pribyl

買這商品的人也買了...

商品描述

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.

Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.

  • Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
  • Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
  • Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
  • Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
  • Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers

商品描述(中文翻譯)

被 Oracle 社群認為是最佳的 Oracle PL/SQL 程式設計指南,這本權威指南正是您需要的,以充分利用 Oracle 強大的程序語言。第六版描述了 PL/SQL 的功能和能力,包括 Oracle Database 12c Release 1。

在過去的二十年中,數以十萬計的 PL/SQL 開發人員從這本書中受益匪淺;這一版延續了這一傳統。本書通過大量的代碼示例和生動的幽默感,解釋了語言基礎知識,探索了高級編碼技巧,並提供了最佳實踐,以幫助您解決現實世界中的問題。

- 使用清晰的指令快速運行 PL/SQL 程式,並進行追蹤、測試、調試和管理程式碼。
- 了解新的 12.1 版本功能,包括 ACCESSIBLE_BY 子句、WITH FUNCTION 和 UDF pragma、BEQUEATH CURRENT_USER 用於視圖,以及新的條件編譯指令。
- 利用大量的代碼示例,從易於理解的示例到可重複使用的封裝工具。
- 通過功能結果緩存和 Oracle 工具(如 PL/Scope 和 PL/SQL 階層分析器)優化 PL/SQL 的性能。
- 使用封裝、程序、函數和觸發器構建模塊化、易於維護的 PL/SQL 應用程式。