title: Why does Oracle think I'm missing a right parenthesis?
body: <p>In Oracle 10i, I'm running the following command:</p>
  
  <pre><code>ALTER TABLE jnrvwchnglst ADD
       ( jnrvwchnglst_userid NUMBER(10) NOT NULL DEFAULT 1 )
  </code></pre>
  
  <p>Yes <code>jnrvwchnglst</code> is an existing table and no <code>jnrvwchnglst_userid</code> is not an existing column.</p>
  
  <p>The Oracle error message is:</p>
  
  <pre><code>ORA-00907: missing right parenthesis
  </code></pre>
  
  <p>What's wrong with this query and why does Oracle think I'm missing a parenthesis?</p>