check-constraint - w3toppers.com

CHECK CONSTRAINT on multiple columns

Yes, define the CHECK CONSTRAINT at the table level CREATE TABLE foo ( bar int NOT NULL, fred varchar(50) NOT NULL, CONSTRAINT CK_foo_stuff CHECK (bar = 1 AND fred =’fish’) ) You are declaring it inline as a column constraint … fred varchar(50) NOT NULL CONSTRAINT CK_foo_fred CHECK (…) … Edit, easier to post than … Read more

query about check constraint [closed]

Since you are using Oracle you can use CHECK constraint saying CONSTRAINT check_dates CHECK (my_date_column BETWEEN date ‘1994-10-25’ AND date ‘2016-05-10’) Your query (as in comment) should be like below create table dob5 ( birthdate date not null, CONSTRAINT check_dates CHECK (birthdate BETWEEN date ‘1994-10-25’ AND date ‘2016-05-10’) ); See this demo fiddle http://sqlfiddle.com/#!4/779f9