Oracle Constraint

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

http://mgracy.blog.163.com/blog/static/57649898200971995942890/