Oracle PL/SQL Programming

by Bill Pribyl (Author), Steven Feuerstein (Author)

• Used

  Paperback
  2009

  $3.25

  This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. This indispensable reference for both novices and experienced Oracle programmers will help you: get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code; optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition; and, explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture. This title also helps you: understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new continue statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL; use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects; and, build modular PL/SQL applications using procedures, functions, triggers, and packages.

• Used

  Paperback
  2002

  $3.25

  This text has been thoroughly revised and updated to include the latest Oracle releases - Oracle8i and Oracle9i - the Internet databases that communicate with other technologies, such as Java, to run powerful e-commerce applications. Oracle has made substantial changes to the PL/SQL language, and developers who want to take full advantage of its power should find the information they need in this book. This new edition of the book includes all PL/S QL language features up to and including Oracle 9i Release 2 (9.2). Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions. In addition, Oracle PL/SQL Programming now contains much-requested new chapters on Oracle triggers, the internal architecture of PL/SQL in the Oracle database, and the use of PL/SQL with Java. The authors have carefully constructed each chapter of this edition with three objectives: to help you take full advantage of PL/SQL, learn to use PL/SQL to solve your problems, and to write efficient, maintainable code. Beginning with an introduction to PL/SQL programming and continuing through advanced PL/SQL topics, the book covers: PL/SQL language fundamentals; PL/SQL program structure; types of program data; the connection of PL/SQL to the underlying database; application construction; managing your PL/SQL code base; if you're new to PL/SQL, reading this book will improve your skills and help your understanding. If you're already a proficient PL/SQL programmer, you'll be able to extract particular techniques for immediate application. Whether you use this book as a teaching guide or reference, you'll find it will have a significant impact on your ability to use PL/SQL more effectively.