title: Add a column to a table with check constraint SQL
body: <p>I want to add a column to a table, then add a check constraint to make sure its greater than 0. I cant seem to get this to run in oracle sl developer. </p>
  
  <pre><code>Alter TABLE store101
  add column Base_salary Number(7,2)
  constraint store101_Base_salary_ck
  check (Base_salary &gt; 0);
  </code></pre>
  
  <p>Error report -
  SQL Error: ORA-00904: : invalid identifier
  00904. 00000 -  "%s: invalid identifier"</p>