title: How do you modify the default to accept Y or N not just Y in SQL
body: <p>I'm trying to modify the default in a column on an existing table but it is not working. I have researched in other sites but it's not working.</p>
  
  <pre><code>ALTER TABLE STOREREPS
  MODIFY (COMM DEFAULT ('Y', 'N'));
  </code></pre>
  
  <p>where my default is set to just <code>Y</code>.</p>
  
  <p>I am using Oracle 11g SQL Developer.                                     </p>