Lesson 14 - Maintaining Data Integrity

08/15/1999


Click here to start


Table of Contents

Maintaining Data Integrity

Objectives

Data Integrity

Types of Constraints

Constraint States

Deferred Constraints

Primary/Unique Key Enforcement

Foreign Key Considerations

Database Triggers

Defining Constraints While Creating a Table

Guidelines for Defining Constraints

Disabling Constraints

Enabling Constraints

Enabling Constraints

Using the EXCEPTIONS Table

Disabling and Enabling Triggers

Dropping Constraints

Dropping Triggers

Getting Constraint Information

Getting Information on Triggers

Summary

Author: Oracle

Email: melody@ecst.csuchico.edu

Home Page: http://www.ecst.csuchico.edu/~melody

Download presentation source