Programming Oracle® Triggers and Stored Procedures, Third Edition

Programming Oracle® Triggers and Stored Procedures, Third Edition

by Kevin Owens
Released December 2003
Publisher(s): Pearson
ISBN: 9780130850331

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

  • Complete tutorial for database developers!

  • Thorough coverage of PL/SQL

  • Practical "cookbook" techniques

    • Effectively create and manage complex databases with Oracle! Systems and database expert Kevin Owens explores PL/SQL, Oracle's answer to the Structured Query Language (SQL), and teaches you what you need to know to build robust and complex databases for your business.

    Using easy-to-follow instructions and examples, this book presents techniques to take advantage of Oracle features such as triggers and stored procedures-features that allow your databases to incorporate business rules which are easy to manage and modify as the business evolves. Topics covered include:

  • Viewing constraints in the data dictionary

  • Complex rule enforcement

  • PL/SQL program units and language features

  • Data types and composite structure

  • Error handling and exceptions

  • Inter-process communications

  • Declarative constraints, including primary key, unique, foreign key, check, and much more

    • Programming Oracle Triggers and Stored Procedures, Third Edition, is an invaluable resource for database developers, designers, and project leaders looking to build and maintain truly intelligent, complex databases

    Table of contents

    1. Copyright
    2. About Prentice Hall Professional Technical Reference
    3. Preface
    4. An Introduction to Relational Database Tables
      1. Before Relational Tables
      2. SQL
      3. Tables
      4. SQL Statements
      5. Table Column Datatypes
      6. Behind Tables
    5. Interacting with Oracle
      1. Simplify SQL*Plus for Yourself on Windows
      2. Connecting
      3. Connecting to an Infrastructure
      4. Disconnecting
      5. Command Line
      6. Changes on the Command Line
      7. Scripts
      8. Script Output
      9. Command Line Arguments
      10. SQL*Plus with Korn Shell
      11. Batch Command Files
      12. SQL*Plus with Active State Perl
      13. Privileges
      14. DUAL
      15. Autotrace
    6. Declarative Constraints
      1. Primary Key
      2. UNIQUE
      3. Foreign Key
      4. Check
      5. NOT NULL Constraints
      6. Default Values
      7. Modifying Constraints
      8. Exception Handling
      9. Data Loads
    7. A Data Model with Constraints
      1. Entity Relationship Diagram
      2. Table Descriptions
      3. DDL
      4. Sample Data
    8. Viewing Constraints in the Data Dictionary
      1. What You Can See
      2. Dictionary Views: An Overview
      3. Constraint Views
      4. USER_CONS_COLUMNS
      5. USER_CONSTRAINTS
      6. Data Dictionary Constraint Scripts
    9. Row Trigger Mechanics
      1. Introduction
      2. Before versus After
      3. Insert Row Trigger Syntax
      4. Trigger Body
      5. Example Row Triggers
      6. A Table with Oracle Constraints and Business Rules
    10. Statement Level Triggers
      1. Sequence of Events
      2. Insert Statement Trigger Syntax
      3. Statement Level Aggregation
      4. Processing Row Captured Data
    11. Complex Rule Enforcement
    12. The PL/SQL Environment
      1. A Hello World Program
      2. Referencing Oracle Packages
      3. USER_OBJECTS
      4. Dependencies among Procedures
      5. USER_DEPENDENCIES
      6. USER_SOURCE
      7. Sharing Code
      8. Compilation Dependency
      9. USER_ERRORS
    13. PL/SQL Program Units
      1. Procedures
      2. Functions
      3. Subprogram Encapsulation: Introduction to Packages
      4. Package Specification
      5. Package Body
      6. Application Partitioning
      7. Data Abstraction
      8. Parameters and Modes
      9. Overloading
    14. PL/SQL Language Features
      1. Comments
      2. Assignments and Statements
      3. Boolean Expression
      4. Expressions with NULL
      5. Logical Operators
      6. String Concatenation
      7. Arithmetic Expressions
      8. Variable Declarations
      9. Types
      10. IF Statement
      11. CASE Statement
      12. LOOP
      13. STRING Manipulation Functions
      14. Miscellaneous String Functions
      15. Numeric Functions
      16. Random Number Generation
      17. Date Functions
      18. Exceptions
      19. Database Access with SQL
      20. Sending Pipe Messages (DBMS_PIPE)
      21. Signaling Events with Alerts (DBMS_ALERT)
      22. Email Notification with Triggers and Alerts

    Product information

    • Title: Programming Oracle® Triggers and Stored Procedures, Third Edition
    • Author(s): Kevin Owens
    • Release date: December 2003
    • Publisher(s): Pearson
    • ISBN: 9780130850331