title: SQL ALTER TABLE with default
body: <p>I'm trying to alter a table in Oracle. I have to give a column in a table a default value of <code>1</code>. This is simple enough when making the table but I have to do it using the <code>ALTER TABLE</code> feature, This is what I have:</p>
  
  <pre><code> ALTER TABLE Stock_Qty
   ADD CONSTRAINT Qty_DEFAULT_Value DEFAULT (Qty 1);
  </code></pre>
  
  <p>It doesn't seem to work.</p>