title: How to use CHECK constraint to restrict non-numeric varchar2 (only alphabets)?
body: <p>I have a column NAME<br>
  It must contain only characters and not numbers<br>
  How do I use CHECK condition:  </p>
  
  <pre><code>CHECK(NAME NOT LIKE '%[0-9]%')
  </code></pre>
  
  <p>or any other method...  </p>
  
  <p>edit: Oracle database is used.</p>