- 数据库
Oracle数据库Constraint约束的常用操作及异常处理
时间:2010-12-5 17:23:32 作者:IT科技 来源:域名 查看: 评论:0
内容摘要:复制altertableteamaddconstraintid_numforeignkey(id)referencesgames(scores)INITIALLYdisable;

数据束
复制alter table team add constraint id_num foreign key(id) references games(scores) INITIALLY disable; alter table team enable constraint id_num EXCEPTIONS INTO EXCEPTIONS; select * from EXCEPTIONS; 1.2.3.4.5.