Programming Oracle: Triggers and Stored Procedures
Material type: TextPublication details: New Jersey: Prentice Hall: 2004Edition: ThirdISBN:- 0130850330
Item type | Current library | Call number | Copy number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|
Standard Loan | Thurles Library Main Collection | 005.7585 OWE (Browse shelf(Opens below)) | 1 | Available | R14901KRCT | ||
Standard Loan | Thurles Library Main Collection | 005.7585 OWE (Browse shelf(Opens below)) | 1 | Available | R14900KRCT | ||
Standard Loan | Thurles Library Main Collection | 005.7585 OWE (Browse shelf(Opens below)) | 1 | Available | R13930KRCC |
Enhanced descriptions from Syndetics:
Using instructions and examples, this book presents techniques to take advantage of Oracle features such as triggers and stored procedures. The topics covered include: Viewing constraints in the data dictionary; PL/SQL program units and language features; and more. It is a useful resource for database developers, designers, and project leaders.
Table of contents provided by Syndetics
- Preface
- 1 An Introduction to Relational Database Tables
- Before Relational Tables
- SQL
- Tables
- SQL Statements
- Table Column Datatypes
- Behind Tables
- 2 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
- 3 Declarative Constraints
- Primary Key
- Unique
- Foreign Key
- Check
- Not Null Constraints
- Default Values
- Modifying Constraints
- Exception Handling
- Data Loads
- 4 A Data Model with Constraints
- Entity Relationship Diagram
- Table Descriptions
- DDL
- Sample Data
- 5 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
- 6 Row Trigger Mechanics
- Introduction
- Before versus After
- Insert Row Trigger Syntax
- Trigger Body
- Example Row Triggers
- A Table with Oracle Constraints and Business Rules
- 7 Statement Level Triggers
- Sequence of Events
- Insert Statement Trigger Syntax
- Statement Level Aggregation
- Processing Row Captured Data
- 8 Complex Rule Enforcement
- 9 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
- 10 PL/SQL Program Units
- Procedures
- Functions
- Subprogram Encapsulation: Introduction to Packages
- Package Specification
- Package Body
- Application Partitioning
- Data Abstraction
- Parameters and Modes
- Overloading
- 11 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
Author notes provided by Syndetics
KEVIN OWENS is the Oracle database administrator at the U.S. Department of the Treasury in Washington, DC.