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

In todays data-driven enterprises, PL/SQL skills are critical in creating, maintaining and designing Oracle databases to support any environment or data type, deliver exceptional scalability, and achieve unparalleled performance for operational, analytical, and other mixed workloads. With this comprehensive update for PL/SQL 21c, Oracle PL/SQL by Example, 6th Edition is the most current PL/SQL guide in print. Updated throughout, it covers everything from basic syntax and program control through the latest optimization and security enhancements.

Step by step, Oracle PL/SQL by Example, 6th Edition walks you through every key task, helping you master Oracle 21c PL/SQL programming techniques on your own.

This books approach fully reflects Elena Rakhimovs 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 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.

The new PL/SQL features and enhancements are as follows:
• PL/SQL Extended Iterators
• PL/SQL Qualified Expressions Enhancements
• SQL Macros
• New JSON Data Type
• New Pragma SUPRESSES_WARNING_6009
• PL/SQL Type Attributes in Non Persistable User Defined Types
• PL/SQL Function Enhanced Result Cache

In this release, Oracle has extended functionality of the numeric FOR loop. For example, you can combine multiple iteration boundaries in the comma-delimited list in a single loop. Prior to Oracle 21c, you would need to specify a distinct FOR loop for a specific iteration boundary.