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
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
SWT/JFace Mechanisms
Combos and Lists
Dialogs
Drag and Drop and the Clipboard
Programming OLE in Windows
A Practitioners Guide to Software Test Design
Boundary Value Testing
Section II - White Box Testing Techniques
When to Stop Testing
Appendix A Brown & Donaldson Case Study
Appendix B Stateless University Registration System Case Study
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Internet Protocol (IP) Routing
Transmission Control Protocol (TCP) Basics
Dynamic Host Configuration Protocol (DHCP) Server Service
Windows Internet Name Service (WINS)
Internet Protocol Security (IPSec)
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Three Sales Process
Chapter Fifteen Sales Management System: Managers Managing Pipelines and Salespeople
Chapter Sixteen Creating and Sustaining High-Performance Sales Cultures
Appendix B Solution Selling: A Scalable Approach
File System Forensic Analysis
Reading the Source Data
Background
Summary
Bibliography
Block Bitmap
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Organizing and Estimating the Work
Risk-Adjusted Financial Management
Quantitative Time Management
Quantitative Methods in Project Contracts
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