title: CHECK constraint on date of birth?
body: <p>I am creating my employee table in Oracle and for emp_date I would like to make it so the date of birth is not way back in the past and can not be set in the future?</p>
  
  <p>Is this too complex to implement in the CREATE TABLE statement? if so then I guess I have to skip it because that is the part where I have to create the constraints.</p>
  
  <pre><code>, emp_dob DATE NOT NULL
  
      CREATE TABLE employee(emp_id NUMBER(4) PRIMARY KEY
  , emp_name VARCHAR2(40) NOT NULL
  , emp_address VARCHAR2(60) NOT NULL
  , emp_tel NUMBER(11) NOT NULL
  , CONSTRAINT emp_tel_length CHECK (LENGTH(emp_tel) BETWEEN 9 and 11)
  , emp_dob DATE NOT NULL
  , CONSTRAINT check_date_of_birth CHECK (emp_dob BETWEEN DATE '1950-01-01' AND sysdate))
  </code></pre>