Programming Oracle Triggers and Stored Procedures

Name: Programming Oracle Triggers and Stored Procedures
Price: 5.7 USD
Availability: InStock
ISBN: 9780130850331

ISBN-10: 0130850330

ISBN-13: 9780130850331

Edition: 3rd 2004 (Revised)

Authors: Kevin Owens

List price: $49.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $5.70

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Advanced Oracle features such as triggers and stored procedures make itpossible to build databases that incorporate business rules - allowing companiesto reengineer processes more quickly and effectively than ever. This is the"bible" for anyone designing complex Oracle databases that incorporatebusiness rules, and it is fully compliant with Oracle 10g. The book presents asimple methodology which yields a highly-maintainable repository of triggersand stored procedures which are easy to manage and modify as the businesschanges. Topics covered include: declarative constraints; analyzing constraintsthrough the data dictionary; PL/SQL program units; embedded SQL; datatypes and composite…

Book details

List price: $49.99
Edition: 3rd
Copyright year: 2004
Publisher: Prentice Hall PTR
Publication date: 12/5/2003
Binding: Paperback
Pages: 448
Size: 6.75" wide x 9.00" long x 1.00" tall
Weight: 1.782
Language: English



Preface



An Introduction to Relational Database Tables


Before Relational Tables


SQL


Tables


SQL Statements


Table Column Datatypes


Behind Tables



Interacting with Oracle


Simplify SQL*Plus for Yourself on Windows


Connecting. Connecting to an Infrastructure


Disconnecting


Command Line


Changes on the Command Line


Scripts


Script Output


Command Line Arguments


SQL*Plus with Korn Shell


Batch Command Files


SQL*Plus with Active State Perl


Privileges


DUAL


Autotrace



Declarative Constraints


Primary Key


Unique


Foreign Key


Check


Not Null Constraints


Default Values


Modifying Constraints


Exception Handling


Data Loads



A Data Model with Constraints


Entity Relationship Diagram


Table Descriptions


DDL


Sample Data



Viewing Constraints in the Data Dictionary


What You Can See


Dictionary Views: An Overview


Constraint Views


User_Cons_Columns


User_Constraints


Data Dictionary Constraint Scripts



Row Trigger Mechanics


Introduction


Before versus After


Insert Row Trigger Syntax


Trigger Body


Example Row Triggers


A Table with Oracle Constraints and Business Rules



Statement Level Triggers


Sequence of Events


Insert Statement Trigger Syntax


Statement Level Aggregation


Processing Row Captured Data



Complex Rule Enforcement



The PL/SQL Environment


A Hello World Program


Referencing Oracle Packages


USER_OBJECTS


Dependencies among Procedures


USER_DEPENDENCIES


USER_SOURCE


Sharing Code


Compilation Dependency


USER_ERRORS



PL/SQL Program Units


Procedures


Functions


Subprogram Encapsulation: Introduction to Packages


Package Specification


Package Body


Application Partitioning


Data Abstraction


Parameters and Modes


Overloading



PL/SQL Language Features


Comments


Assignments and Statements


Boolean Expression


Expressions with Null


Logical Operators


String Concatenation


Arithmetic Expressions


Variable Declarations


Types


IF Statement


CASE Statement


LOOP


STRING Manipulation Functions


Miscellaneous String Functions


Numeric Functions


Random Number Generation


Date Functions


Exceptions


Database Access with SQL


Sending Pipe Messages (DBMS_PIPE)


Signaling Events with Alerts (DBMS_ALERT)


Email Notification with Triggers and Alerts


Index