Oracle PL/SQL by Example, 5/e (Paperback)

Benjamin Rosenzweig, Elena Rakhimov

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

商品描述

Using PL/SQL for Oracle Database 12c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle® PL/SQL by Example, Fifth Edition, teaches all the PL/SQL skills you’ll need, through real-world labs, extensive examples, exercises, and projects. Now fully updated for the newest version of PL/SQL, it covers everything from basic syntax and program control through the latest optimization and security enhancements.

 

Step by step, you’ll walk through every key task, mastering today’s most valuable Oracle 12cPL/SQL programming techniques on your own. Start by downloading projects and exercises from informit.com/title/0133796787. Once you’ve done an exercise, the authors don’t just present the answer: They offer an in-depth discussion introducing deeper insights and modern best practices.

 

This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL to professionals at Columbia University. New database developers and DBAs can use it to get productive fast; experienced PL/SQL programmers will find it to be a superb Oracle Database 12csolutions reference.

 

New in This Edition

  • Updated code examples throughout
  • Result-caching of invoker’s right functions for better performance
  • Extended support for PL/SQL-only data types in dynamic SQL, OCI, and JDBC
  • Security enhancements, including ACCESSIBLE BY whitelists, improved privilege control, and Invisible Columns

 

Other topics covered

  • Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL’s role in PL/SQL
  • Using conditional and iterative program control, including CONTINUE and CONTINUE WHEN
  • Efficiently handling errors and exceptions
  • Working with cursors and triggers, including compound triggers
  • Using stored procedures, functions, and packages to write modular code that other programs can run
  • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features

 

商品描述(中文翻譯)

使用 PL/SQL for Oracle Database 12c,您可以在任何環境中(包括雲端)建立提供前所未有的性能和效率的解決方案。《Oracle® PL/SQL by Example, Fifth Edition》通過真實世界的實驗室、廣泛的例子、練習和項目,教授您所需的所有 PL/SQL 技能。現在已完全更新至最新版本的 PL/SQL,涵蓋從基本語法和程序控制到最新的優化和安全增強功能。

逐步進行,您將獨立掌握今天最有價值的 Oracle 12c PL/SQL 編程技術的每個關鍵任務。首先從 informit.com/title/0133796787 下載項目和練習。完成練習後,作者不僅提供答案,還提供深入討論,介紹更深入的見解和現代最佳實踐。

本書的方法完全反映了作者在哥倫比亞大學教授 PL/SQL 給專業人士的屢獲殊榮的經驗。新的數據庫開發人員和 DBA 可以使用它快速提高生產力;有經驗的 PL/SQL 程序員將發現它是一本出色的 Oracle Database 12c 解決方案參考書。

本版新增內容:

- 更新了整個代碼示例
- 對於更好的性能,對調用者權限函數進行了結果緩存
- 在動態 SQL、OCI 和 JDBC 中擴展了對僅限於 PL/SQL 的數據類型的支持
- 安全增強功能,包括 ACCESSIBLE BY 白名單、改進的權限控制和隱藏列

其他涵蓋的主題:

- 掌握基本的 PL/SQL 概念和語言基礎,並了解 SQL 在 PL/SQL 中的作用
- 使用條件和迭代程序控制,包括 CONTINUE 和 CONTINUE WHEN
- 高效處理錯誤和異常
- 使用游標和觸發器,包括複合觸發器
- 使用存儲過程、函數和包來編寫其他程序可以運行的模塊化代碼
- 使用集合、物件關聯特性、本地動態 SQL、批量 SQL 和其他高級功能