大家帮忙看下,这样写可以吗?
alter table student add memberflag number not null check(memberflag in(0,1));
alter table student add bememberdate date check(memberflag=0 and bememberdate is not null) and (memberflag=0 and bememberdate is null);
那这样哪?单独把查询条件列出来:
alter table xxzx_student add memberflag number(1) not null default 0;
alter table xxzx_student add bememberdate date ;
alter table xxzx_student add constraint ck_st_mumberflag check(memberflag in(0,1))
alter table xxzx_student add constraint ck_st_bemumberdate check((MEMBERFLAG=1 and
BEMEMBERDATE is not null) or (MEMBERFLAG=0 and BEMEMBERDATE is null));