Chapter Three. Declarative Constraints
3.1 PRIMARY KEY
3.1.1 Creating the Constraint
3.1.2 Naming the Constraint
3.1.3 The Primary Key Index
3.1.4 Sequences
3.1.5 Sequences in Code
3.1.6 Concatenated Primary Key
3.1.7 Extra Indexes with Pseudo Keys
3.1.8 Enable, Disable, and Drop
3.1.9 Deferrable Option
3.1.10 NOVALIDATE
3.1.11 Error Handling in PL/SQL
3.2 UNIQUE
3.2.1 Combining NOT NULL, CHECK with UNIQUE Constraints
3.2.2 Students Table Example
3.2.3 Deferrable and NOVALIDATE Options
3.2.4 Error Handling in PL/SQL
3.3 FOREIGN KEY
3.3.1 Four Types of Errors
3.3.2 Delete Cascade
3.3.3 Mandatory Foreign Key Columns
3.3.4 Referencing the Parent Syntax
3.3.5 Referential Integrity across Schemas and Databases
3.3.6 Multiple Parents and DDL Migration
3.3.7 Many-to-Many ...
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
