用if逻辑oraclesql检查约束-checkconstraintwithiflogicoraclesql

3  

Sometimes it is easier to express using NOT to define what is not allowed:

有时使用NOT来表达不允许的内容更容易表达:

CHECK (NOT (behaviour = 'bad' AND treat = 'lollies'))

... which means same as:

......这意味着:

CHECK (behaviour != 'bad' OR treat != 'lollies')

It is easy to get this wrong, as other answers have shown!

很容易弄错,正如其他答案所示!

0  

Try this

create table children ( 
        childname VARCHAR2(50), behaviour VARCHAR2(50),treats VARCHAR2(50),
        constraint behave_treat check (behaviour = 'bad' AND treats != 'lollies')
        ) 

0  

ALTER TABLE child 
  ADD CONSTRAINT bad_behaviour_CK 
    CHECK (NOT (behaviour = 'bad' AND treat = 'lollies')) ;

Tesed in SQL-Fiddle

在SQL-Fiddle中编写