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
Java I/O
The Console: System.out, System.in, and System.err
Reading Files
JAR Archives
Performance
Nonblocking I/O
SQL Tips & Techniques (Miscellaneous)
Creating Indexes for Fast Data Retrieval
Working with Data BLOBs and Text
Monitoring and Enhancing MS-SQL Server Performance
Exploiting MS-SQL Server Built-in Stored Procedures
Working with SQL Database Data Across the Internet
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Configuring Call Transfer and Forward
Step 7: Configuring Cisco CME Call Processing Features
Summary
The dialbyextension.aef Script
Table vm_mbxusers
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Tcpdump
IDS and IPS Architecture
Snort
NFR Security
Laws, Standards, and Organizations
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The AJAX Control Toolkit
Built-in Application Services
Remote Method Calls with ASP.NET AJAX
Building AJAX Applications with ASP.NET
.NET System Management Services
Using the System.Management Namespace
Querying WMI
Instrumenting .NET Applications with WMI
WMI Providers
WMI Security
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