Oracle PL/SQL ProgrammingFor the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL. The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers. The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization. Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning. |
Contents
1 | |
3 | |
25 | |
55 | |
81 | |
83 | |
105 | |
Exception Handlers | 125 |
Data Retrieval | 460 |
Dynamic SQL and Dynamic PLSQL | 518 |
Part V | 563 |
Procedures Functions and Parameters | 565 |
Packages | 622 |
Triggers | 655 |
Managing PLSQL Code | 708 |
IO and PLSQL | 777 |
Part III | 163 |
Working with Program Data | 165 |
Strings | 189 |
Numbers | 226 |
Dates and Timestamps | 257 |
Records | 302 |
Collections | 318 |
Miscellaneous Datatypes | 382 |
Part IV | 423 |
DML and Transaction Management | 425 |
Part VI | 821 |
Application Security and PLSQL | 823 |
Inside PLSQL | 883 |
Globalization and Localization in PLSQL | 939 |
ObjectOriented Aspects of PLSQL | 981 |
Calling Java from PLSQL | 1041 |
External Procedures | 1078 |
Regular Expression Metacharacters and Function Parameters | 1109 |
Number Format Models | 1114 |
Date Format Models | 1117 |