17,090
社区成员
发帖
与我相关
我的任务
分享
SQL>
SQL> create table abcd(id number,type varchar2(2),schdeule_id char(20),
2 constraint abcd_1 foreign key(schdeule_id) references abc(a),
3 constraint abcd_2 check(type in ('aa','bb','cc') and case type when 'aa' then schdeule_id else '1' end is not null));
Table created
SQL> insert into abcd values(1,'dd',null);
insert into abcd values(1,'dd',null)
ORA-02290: 违反检查约束条件 (W.ABCD_2)
SQL> insert into abcd values(1,'bb',null);
1 row inserted
SQL> insert into abcd values(2,'aa',null);
insert into abcd values(2,'aa',null)
ORA-02290: 违反检查约束条件 (W.ABCD_2)
SQL> insert into abcd values(3,'aa','2');
1 row inserted
SQL> insert into abcd values(4,'aa','123');
insert into abcd values(4,'aa','123')
ORA-02291: 违反完整约束条件 (W.ABCD_1) - 未找到父项关键字
SQL>