SQL> alter table xxx add constraint PK_XXX primary key(unid);
SQL> alter table xxx add constraint UK_XXX unique(xxx,xxx);
SQL> alter table xxx add constraint FK_XXX foreign key(xxx) references xxx(xxx);
SQL> alter table xxx add constraint check(xxx like '1%‘)
enable(disable)运行过程中 validate(novalidate)已经存在的
initially deffered (immediate) commit的时候check,DML的时候 前提是deferable的才可以modify
SQL> alter session set constraints=deffered (immediate)
增加子句exceptions into exceptions
DBA_CONSTRAINTS
DBA_CONS_COLUMN