Название: Oracle PL/SQL by Example, 6th Edition (Final)
Автор: Benjamin Rosenzweig, Elena Rakhimov
Издательство: Oracle Press/Pearson Education
Год: 2023
Страниц: 849
Язык: английский
Формат: epub (true)
Размер: 33.0 MB

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.

Oracle 21c has introduced several new features and improvements for PL/SQL. This introduction briefly describes features not covered in this book and points you to specific chapters for features that are within the scope of this book. The list of features described here is also available in the “Changes in This Release for Oracle Database PL/SQL Language Reference” section of the PL/SQL Language Reference manual offered as part of Oracle help available online.

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

Who This Book Is For:
This book is intended for anyone who needs a quick but detailed introduction to programming with Oracle’s PL/SQL language. The ideal readers are those with some relational database experience, with some Oracle experience, specifically with SQL, SQL*Plus, and SQL Developer, but with little or no experience with PL/SQL or with most other programming languages.

The content of this book is based primarily on the material that was taught in an Introduction to PL/SQL class at Columbia University’s Computer Technology and Applications (CTA) program in New York City. The student body was rather diverse, in that there were some students who had years of experience with information technology (IT) and programming, but no experience with Oracle PL/SQL, and then there were those with absolutely no experience in IT or programming. The content of the book, like the class, is balanced to meet the needs of both extremes.