Flylib.com
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
Year: 2003
Pages: 111
Authors:
Kevin Owens
BUY ON AMAZON
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
Year: 2003
Pages: 111
Authors:
Kevin Owens
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
IT Project Management Overview
Scope Planning
Schedule Planning
Comprehensive Project Plan
Appendix B Standard IT Project Documents
Metrics and Models in Software Quality Engineering (2nd Edition)
Run Charts
In-Process Metrics and Reports
How Do You Know Your Product Is Good Enough to Ship?
Metrics and Lessons Learned for Object-Oriented Projects
1 Definition and Measurements of System Availability
The .NET Developers Guide to Directory Services Programming
Summary
Directory CRUD Operations
Summary
LDIFDE
Error 0x80070005: General access denied error.
Introduction to 80x86 Assembly Language and Computer Architecture
Parts of a Computer System
String Operations
Decimal Arithmetic
Appendix B Useful MS-DOS Commands
Appendix D 80x86 Instructions (by Mnemonic)
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Basic Database Terminology
Using VIEW
Network Address Data Types
Understanding How PostgreSQL Executes a Query
Client 3Processing SQL Commands
Understanding Digital Signal Processing (2nd Edition)
INVERSE DFT
IMPULSE INVARIANCE IIR FILTER DESIGN METHOD
TIME-DOMAIN ANALYTIC SIGNAL GENERATION
Chapter Eleven. Signal Averaging
FILTERING ASPECTS OF TIME-DOMAIN AVERAGING
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies