title: How to add constraint of specific value of column to table in Oracle?
body: <p>I have table employee with a column that is called 'sex'
  Why this alter is not working:</p>
  
  <pre><code>ALTER TABLE employee
  WITH NOCHECK ADD CONSTRAINT EMP_SEX
  CHECK (Sex in ('M','F'));
  </code></pre>
  
  <p>Or for table bank this is not working:</p>
  
  <pre><code>ALTER TABLE Account
  WITH NOCHECK ADD CONSTRAINT chk_account_type CHECK (Type IN ('saving', 'credit', 'HOME LOAN', 'PERSONAL LOAN', 'TERM DEPOSIT', 'CHECK', 'ISAVER', 'SHARE' ));
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>SQL&gt; ALTER TABLE employee
  WITH NOCHECK ADD CONSTRAINT EMP_SEX
  CHECK (Sex in ('M','F'));
    2    3  WITH NOCHECK ADD CONSTRAINT EMP_SEX
  *
  ERROR at line 2:
  ORA-01735: invalid ALTER TABLE option
  </code></pre>
  
  <p>Or even I tried this-></p>
  
  <pre><code>ALTER TABLE Account
  ADD CONSTRAINT chk_account_type CHECK ( Type = 'a'));
  </code></pre>