Oracle Pl/SQL by Example 6/e
暫譯: Oracle Pl/SQL 實例解析 第6版
Rosenzweig, Benjamin, Rakhimov, Elena
- 出版商: Prentice Hall
- 出版日期: 2023-05-21
- 定價: $2,600
- 售價: 9.5 折 $2,470
- 語言: 英文
- 頁數: 480
- 裝訂: Quality Paper - also called trade paper
- ISBN: 0138062838
- ISBN-13: 9780138062835
-
相關分類:
Oracle、SQL
-
相關翻譯:
Oracle PL\SQL 實例精解 (原書第6版) (簡中版)
立即出貨 (庫存 < 3)
商品描述
Using PL/SQL for Oracle Database 21c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle PL/SQL by Example, Sixth Edition, teaches all the PL/SQL skills you'll need, through real-world labs and extensive examples. Now fully updated for the newest version of PL/SQL 21c, it covers everything from basic syntax and program control through the latest optimization and tuning enhancements.
Step by step, you'll walk through every key task, mastering today's most valuable Oracle 21c PL/SQL programming techniques on your own. Start by downloading the supporting schema and exercises from informit.com/title/9780138062835. Once you've done an exercise, the author doesn't just present the answer: She offers an in-depth discussion introducing deeper insights and modern best practices.
This book's approach fully reflects the author's award-winning experience teaching PL/SQL to professionals at Columbia University in New York City. 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 21c solutions reference.
New in This Edition
- Updated code examples throughout
- New iteration controls for the FOR LOOP statement, such as stepped range, multiple iterations, collection, and cursor iterations
- Enhancements for PL/SQL qualified expressions
- Performance enhancements for PL/SQL functions, such as SQL macro, and better control of the result cache
Other Topics Covered
- Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL's role in PL/SQL
- Using conditional and iterative program controls
- 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 21c,您可以在任何環境中(包括雲端)構建提供前所未有性能和效率的解決方案。《Oracle PL/SQL by Example》第六版通過真實世界的實驗室和廣泛的範例教授您所需的所有 PL/SQL 技能。此版本已全面更新至最新的 PL/SQL 21c,涵蓋從基本語法和程式控制到最新的優化和調整增強功能的所有內容。
逐步地,您將掌握每一個關鍵任務,獨立學習當今最有價值的 Oracle 21c PL/SQL 程式設計技術。首先,從 informit.com/title/9780138062835 下載支援的架構和練習。一旦您完成了一個練習,作者不僅僅提供答案:她還提供深入的討論,介紹更深層的見解和現代最佳實踐。
本書的教學方法充分反映了作者在紐約市哥倫比亞大學教授 PL/SQL 給專業人士的獲獎經驗。新的資料庫開發人員和 DBA 可以利用它快速提高生產力;有經驗的 PL/SQL 程式設計師會發現這是一本出色的 Oracle Database 21c 解決方案參考書。
**本版新內容**
- 全書更新的程式碼範例
- FOR LOOP 語句的新迭代控制,例如步進範圍、多次迭代、集合和游標迭代
- PL/SQL 合格表達式的增強功能
- PL/SQL 函數的性能增強,例如 SQL 宏,以及更好的結果快取控制
**其他涵蓋主題**
- 精通基本 PL/SQL 概念和語言基礎,理解 SQL 在 PL/SQL 中的角色
- 使用條件和迭代程式控制
- 高效處理錯誤和例外
- 使用游標和觸發器,包括複合觸發器
- 使用儲存過程、函數和套件編寫其他程式可以運行的模組化程式碼
- 使用集合、物件關聯特性、本地動態 SQL、大量 SQL 和其他進階功能