Oracle PL/SQL Programming - Brossura

Feuerstein, Steven; Pribyl, Bill

Brossura

ISBN 10: 0596009771 ISBN 13: 9780596009779

Casa editrice: Oreilly & Associates Inc, 2005

Riassunto

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.

Su questo libro

L'autore:

Steven Feuerstein is considered the world's leading expert on the Oracle PL/SQL language and an excellent evangelist for the book and the PL/SQL language in general. He travels extensively, giving seminars, keynote addresses, and technical presentations at database conferences. He writes for Oracle Magazine and other publications, and is the most popular "columnist" for the Oracle Technology Network (OTN), which gets several million hits a month. He is a very popular writer and speaker, well known and respected by Oracle Corporation and its users worldwide.

Bill Pribyl, author, teacher, and software consultant, is the primary author of Learning Oracle PL/SQL, and the co-author of Oracle PL/SQL Programming and its companion pocket reference, all published by O'Reilly Media. An Oracle user since 1986, Bill has consulted on many aspects of using Oracle products. He recently spearheaded PLNet.org, a Web-based repository where developers can share open source PL/SQL.

Contenuti:

Dedication; Preface; Objectives of This Book; Structure of This Book; Conventions Used in This Book; Which Platform or Version?; About the Code; Safari Enabled; Comments and Questions; Acknowledgments; Part I: Programming in PL/SQL; Chapter 1: Introduction to PL/SQL; 1.1 What Is PL/SQL?; 1.2 The Origins of PL/SQL; 1.3 So This Is PL/SQL; 1.4 About PL/SQL Versions; 1.5 Resources for PL/SQL Developers; 1.6 Some Words of Advice; Chapter 2: Creating and Running PL/SQL Code; 2.1 SQL*Plus; 2.2 Performing Essential PL/SQL Tasks; 2.3 Calling PL/SQL from Other Languages; Chapter 3: Language Fundamentals; 3.1 PL/SQL Block Structure; 3.2 The PL/SQL Character Set; 3.3 Identifiers; 3.4 Literals; 3.5 The Semicolon Delimiter; 3.6 Comments; 3.7 The PRAGMA Keyword; 3.8 Labels; Part II: PL/SQL Program Structure; Chapter 4: Conditional and Sequential Control; 4.1 IF Statements; 4.2 CASE Statements and Expressions; 4.3 The GOTO Statement; 4.4 The NULL Statement; Chapter 5: Iterative Processing with Loops; 5.1 Loop Basics; 5.2 The Simple Loop; 5.3 The WHILE Loop; 5.4 The Numeric FOR Loop; 5.5 The Cursor FOR Loop; 5.6 Loop Labels; 5.7 Tips for Iterative Processing; Chapter 6: Exception Handlers; 6.1 Exception-Handling Concepts and Terminology; 6.2 Defining Exceptions; 6.3 Raising Exceptions; 6.4 Handling Exceptions; 6.5 Building an Effective Error Management Architecture; 6.6 Making the Most of PL/SQL Error Management; Part III: PL/SQL Program Data; Chapter 7: Working with Program Data; 7.1 Naming Your Program Data; 7.2 Overview of PL/SQL Datatypes; 7.3 Declaring Program Data; 7.4 Programmer-Defined Subtypes; 7.5 Conversion Between Datatypes; Chapter 8: Strings; 8.1 String Datatypes; 8.2 Working with Strings; 8.3 String Function Quick Reference; Chapter 9: Numbers; 9.1 Numeric Datatypes; 9.2 Number Conversions; 9.3 Numeric Functions; Chapter 10: Dates and Timestamps; 10.1 Datetime Datatypes; 10.2 Getting the Date and Time; 10.3 Interval Datatypes; 10.4 Datetime Conversions; 10.5 Date and Timestamp Literals; 10.6 Interval Conversions; 10.7 Interval Literals; 10.8 CAST and EXTRACT; 10.9 Datetime Arithmetic; 10.10 Date/Time Functions; Chapter 11: Records; 11.1 Records in PL/SQL; Chapter 12: Collections; 12.1 Collections Overview; 12.2 Collection Methods (Built-Ins); 12.3 Working with Collections; 12.4 Nested Table Multiset Operations; 12.5 Maintaining Schema-Level Collections; Chapter 13: Miscellaneous Datatypes; 13.1 The BOOLEAN Datatype; 13.2 The RAW Datatype; 13.3 The UROWID and ROWID Datatypes; 13.4 The LOB Datatypes; 13.5 Working with LOBs; 13.6 Predefined Object Types; Part IV: SQL in PL/SQL; Chapter 14: DML and Transaction Management; 14.1 DML in PL/SQL; 14.2 Bulk DML with the FORALL Statement; 14.3 Transaction Management; 14.4 Autonomous Transactions; Chapter 15: Data Retrieval; 15.1 Cursor Basics; 15.2 Working with Implicit Cursors; 15.3 Working with Explicit Cursors; 15.4 BULK COLLECT; 15.5 SELECT ... FOR UPDATE; 15.6 Cursor Variables and REF CURSORs; 15.7 Cursor Expressions; Chapter 16: Dynamic SQL and Dynamic PL/SQL; 16.1 NDS Statements; 16.2 Binding Variables; 16.3 Working with Objects and Collections; 16.4 Dynamic PL/SQL; 16.5 Recommendations for NDS; 16.6 When to Use DBMS_SQL; 16.7 NDS Utility Package; Part V: PL/SQL Application Construction; Chapter 17: Procedures, Functions, and Parameters; 17.1 Modular Code; 17.2 Procedures; 17.3 Functions; 17.4 Parameters; 17.5 Local Modules; 17.6 Module Overloading; 17.7 Forward Declarations; 17.8 Advanced Topics; 17.9 Go Forth and Modularize!; Chapter 18: Packages; 18.1 Why Packages?; 18.2 Rules for Building Packages; 18.3 Rules for Calling Packaged Elements; 18.4 Working with Package Data; 18.5 When to Use Packages; 18.6 Packages and Object Types; Chapter 19: Triggers; 19.1 DML Triggers; 19.2 DDL Triggers; 19.3 Database Event Triggers; 19.4 INSTEAD OF Triggers; 19.5 AFTER SUSPEND Triggers; 19.6 Maintaining Triggers; Chapter 20: Managing PL/SQL Code; 20.1 Managing Code in the Database; 20.2 Using Native Compilation; 20.3 Using the Optimizing Compiler and Compile-Time Warnings; 20.4 Conditional Compilation; 20.5 Testing PL/SQL Programs; 20.6 Debugging PL/SQL Programs; 20.7 Tuning PL/SQL Programs; 20.8 Protecting Stored Code; Chapter 21: I/O and PL/SQL; 21.1 Displaying Information; 21.2 Reading and Writing Files; 21.3 Sending Email; 21.4 Working with Web-Based Data (HTTP); 21.5 Other Types of I/O Available in PL/SQL; Part VI: Advanced PL/SQL Topics; Chapter 22: Application Security and PL/SQL; 22.1 Security Overview; 22.2 Encryption; 22.3 Row-Level Security; 22.4 Application Contexts; 22.5 Fine-Grained Auditing; Chapter 23: Inside PL/SQL; 23.1 Looking Under the Hood; 23.2 PL/SQL's Optimizing Compiler; 23.3 Dependency Management; 23.4 Execution Authority Models; 23.5 PL/SQL and Oracle Memory; 23.6 Server-Side PL/SQL Processing: Reprise; 23.7 What You Need to Know; Chapter 24: Globalization and Localization in PL/SQL; 24.1 Overview and Terminology; 24.2 Unicode Primer; 24.3 Character Semantics; 24.4 String Sort Order; 24.5 Multilingual Information Retrieval; 24.6 Date/Time; 24.7 Currency Conversion; 24.8 Globalization Development Kit for PL/SQL; Chapter 25: Object-Oriented Aspects of PL/SQL; 25.1 Introduction to Oracle's Object Features; 25.2 An Extended Example; 25.3 Object Views; 25.4 Maintaining Object Types and Object Views; 25.5 Pontifications; Chapter 26: Calling Java from PL/SQL; 26.1 Oracle and Java; 26.2 Getting Ready to Use Java in Oracle; 26.3 A Simple Demonstration; 26.4 Using loadjava; 26.5 Using dropjava; 26.6 Managing Java in the Database; 26.7 Using DBMS_JAVA; 26.8 Publishing and Using Java in PL/SQL; Chapter 27: External Procedures; 27.1 Introduction to External Procedures; 27.2 The Oracle Net Configuration; 27.3 Setting Up Multithreaded Mode; 27.4 Creating an Oracle Library; 27.5 Writing the Call Specification; 27.6 Raising an Exception from the Called C Program; 27.7 Nondefault Agents; 27.8 Maintaining External Procedures; Part VII: Appendixes; Appendix A: Regular Expression Metacharacters and Function Parameters; A.1 Metacharacters; A.2 Function Parameters; Appendix B: Number Format Models; Appendix C: Date Format Models; Colophon;

Su questa edizione

• Editore: Oreilly & Associates Inc
• Data di pubblicazione: 2005
• ISBN 10: 0596009771
• ISBN 13: 9780596009779
• Rilegatura: Copertina flessibile
• Numero edizione: 4
• Numero di pagine: 1171