Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)
Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)
ISBN: 0130850330
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 111
Pages: 111
Authors: Kevin Owens
- Main Page
- Table of content
- Copyright
- About Prentice Hall Professional Technical Reference
- Preface
- Who Will Benefit from This Book?
- How Is This Book Structured?
- Conventions
- Acknowledgments
- Chapter One. An Introduction to Relational Database Tables
- 1.1 Before Relational Tables
- 1.2 SQL
- 1.3 Tables
- 1.4 SQL Statements
- 1.5 Table Column Datatypes
- 1.6 Behind Tables
- Chapter Two. Interacting with Oracle
- 2.1 Simplify SQLPlus for Yourself on Windows
- 2.2 Connecting
- 2.3 Connecting to an Infrastructure
- 2.4 Disconnecting
- 2.5 Command Line
- 2.6 Changes on the Command Line
- 2.7 Scripts
- 2.8 Script Output
- 2.9 Command Line Arguments
- 2.10 SQLPlus with Korn Shell
- 2.11 Batch Command Files
- 2.12 SQLPlus with Active State Perl
- 2.13 Privileges
- 2.14 DUAL
- 2.15 Autotrace
- Chapter Three. Declarative Constraints
- 3.1 Primary Key
- 3.2 UNIQUE
- 3.3 Foreign Key
- 3.4 Check
- 3.5 NOT NULL Constraints
- 3.6 Default Values
- 3.7 Modifying Constraints
- 3.8 Exception Handling
- 3.9 Data Loads
- Chapter Four. A Data Model with Constraints
- 4.1 Entity Relationship Diagram
- 4.2 Table Descriptions
- 4.3 DDL
- 4.4 Sample Data
- Chapter Five. Viewing Constraints in the Data Dictionary
- 5.1 What You Can See
- 5.2 Dictionary Views: An Overview
- 5.3 Constraint Views
- 5.4 USER_CONS_COLUMNS
- 5.5 USER_CONSTRAINTS
- 5.6 Data Dictionary Constraint Scripts
- Chapter Six. Row Trigger Mechanics
- 6.1 Introduction
- 6.2 Before versus After
- 6.3 Insert Row Trigger Syntax
- 6.4 Trigger Body
- 6.5 Example Row Triggers
- 6.6 A Table with Oracle Constraints and Business Rules
- Chapter Seven. Statement Level Triggers
- 7.1 Sequence of Events
- 7.2 Insert Statement Trigger Syntax
- 7.3 Statement Level Aggregation
- 7.4 Processing Row Captured Data
- Chapter Eight. Complex Rule Enforcement
- Chapter Nine. The PLSQL Environment
- 9.1 A Hello World Program
- 9.2 Referencing Oracle Packages
- 9.3 USER_OBJECTS
- 9.4 Dependencies among Procedures
- 9.5 USER_DEPENDENCIES
- 9.6 USER_SOURCE
- 9.7 Sharing Code
- 9.8 Compilation Dependency
- 9.9 USER_ERRORS
- Chapter Ten. PLSQL Program Units
- 10.1 Procedures
- 10.2 Functions
- 10.3 Subprogram Encapsulation: Introduction to Packages
- 10.4 Package Specification
- 10.5 Package Body
- 10.6 Application Partitioning
- 10.7 Data Abstraction
- 10.8 Parameters and Modes
- 10.9 Overloading
- Chapter Eleven. PLSQL Language Features
- 11.1 Comments
- 11.2 Assignments and Statements
- 11.3 Boolean Expression
- 11.4 Expressions with NULL
- 11.5 Logical Operators
- 11.6 String Concatenation
- 11.7 Arithmetic Expressions
- 11.8 Variable Declarations
- 11.9 Types
- 11.10 IF Statement
- 11.11 CASE Statement
- 11.12 LOOP
- 11.13 STRING Manipulation Functions
- 11.14 Miscellaneous String Functions
- 11.15 Numeric Functions
- 11.16 Random Number Generation
- 11.17 Date Functions
- 11.18 Exceptions
- 11.19 Database Access with SQL
- 11.20 Sending Pipe Messages (DBMS_PIPE)
- 11.21 Signaling Events with Alerts (DBMS_ALERT)
- 11.22 Email Notification with Triggers and Alerts
Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)
ISBN: 0130850330
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 111
Pages: 111
Authors: Kevin Owens
- Understanding SQL Basics and Creating Database Files
- Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
- Working with Queries, Expressions, and Aggregate Functions
- Working with Ms-sql Server Information Schema View
- Repairing and Maintaining MS-SQL Server Database Files