Oracle PL/SQL by Example, 5/e (Paperback)
暫譯: Oracle PL/SQL 實例解析，第5版 (平裝本)

Benjamin Rosenzweig, Elena Rakhimov

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

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

相關主題

商品描述

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 針對 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 解決方案參考書。

本版新內容
- 全書更新的程式碼範例
- 改進的性能，支持調用者權限函數的結果快取
- 擴展對 PL/SQL 專用資料類型在動態 SQL、OCI 和 JDBC 中的支持
- 安全性增強，包括可由白名單訪問、改進的權限控制和隱形欄位

其他涵蓋主題
- 精通基本 PL/SQL 概念和語言基礎，理解 SQL 在 PL/SQL 中的角色
- 使用條件和迭代程式控制，包括 CONTINUE 和 CONTINUE WHEN
- 高效處理錯誤和例外
- 使用游標和觸發器，包括複合觸發器
- 使用儲存過程、函數和套件編寫其他程式可以運行的模組化程式碼
- 使用集合、物件關聯特性、本地動態 SQL、大量 SQL 和其他進階功能

類似商品