Constraint
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
A constraint is a data rule or restriction that is enforced within the database rather than at application or object level.
The following constraint types are available in Oracle, as can be confirmed by selecting from the DBA_CONSTRAINTS view:
| Type Code | Type Description | Acts On Level |
|---|---|---|
| C | Check on a table | Column |
| O | Read Only on a view | Object |
| P | Primary Key | Object |
| R | Referential AKA Foreign Key | Column |
| U | Unique Key | Column |
| V | Check Option on a view | Object |
Users may need to write database triggers to enforce complicated constrains that cannot be handled with the above declarations.
Also see
- primary key
- unique key
- foreign key (references)
- check constraint
- NOT NULL
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
