The Best-Selling PLSQL Books of All Time

For 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.

Find tips for creating efficient PL/SQL codeIf you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken―you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more. Discover how to. Write efficient, easy-to-maintain codeTest and debug PL/SQL routinesIntegrate SQL and PL/SQLApply PL/SQL best practicesUse new features introduced in Oracle 9i and 10g.

Written by Oracle insider Scott Urman, this guide will have you expertly programming for Oracle7 with PL/SQL - the language that combines the power of procedural programming with the flexibility of the SQL query language. The book begins with an overview of PL/SQL and the rationale behind its development.

It then continues to build your Oracle7 PL/SQL skills with a solid foundation in the basics of PL/SQL, including the syntax and semantics of this unique language, as well as an understanding of SQL; advice on using stored procedures and packages, to help you take advantage of these powerful Oracle features; tips and techniques for testing and debugging your PL/SQL code, using a variety of methods and tools; instructions on using PL/SQL in diverse environments such as SQL Plus, Oracle Developer 2000, the Oracle Precompilers and OCL; information about advanced features, such as dynamic programming, intersession communication, and job scheduling. Also included are the latest enhancements available in version 2.3 such as file input/output and cursor variables, and suggestions for tuning and optimizing your PL/SQL applications to make them run as fast as possible. Everything in this book is presented in clear language, with many helpful illustrations and code samples to get you going immediately with your own full featured PL/SQL applications.