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
Certified Ethical Hacker Exam Prep
Apply Your Knowledge
Database Overview
Wireless Hacking Tools
Summary
Physical Security and Social Engineering
WebLogic: The Definitive Guide
Configuring a Simple Web Cluster
Handling System Failure
The Server Life Cycle
UDDI
Accessing MBeans
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Autocorrect Text as a Buffer Changes
Finding the Greatest or Least Value in a Container
Representing a Dynamically Sized Numerical Vector
Computing the Fast Fourier Transform
Working with Polar Coordinates
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Using DMAIC to Improve Speed, Quality, and Cost
Voice of the Customer (VOC)
Data Collection
Complexity Value Stream Mapping and Complexity Analysis
Selecting and Testing Solutions
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Special Excel Issues
Conclusion
Introduction to the Actions Pane
Strong Names
Advanced Topic: Deploying Network Solutions to Be Cached Locally
VBScript in a Nutshell, 2nd Edition
VBScripts History and Uses
Debugging
Program Flow
Section A.17. Variable Declaration
Appendix D. Locale IDs
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