title: alter the size of column in table containing data
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/8404194/how-to-make-a-varchar2-field-shorter-in-oracle">How to make a varchar2 field shorter in Oracle?</a>  </p>
  </blockquote>
  
  
  
  <p>In Oracle(9i and above)</p>
  
  <pre><code> Alter table employee  
   MODIFY ename varchar2(10);
  </code></pre>
  
  <p>I want to alter the column ename of table employee from varchar2(30) to varchar2(10)</p>
  
  <ul>
  <li><p>Case1 : if the table has data having ename column containing values which are of length less than 10 char(i mean it can fit in varchar2(10) comfortably) - is this allowed by oracle ?</p></li>
  <li><p>Case 2: if the table has data having ename column containing values which are of length greater than 10 char(i mean it can not fit in varchar2(10)) - is this not allowed by oracle ?</p></li>
  </ul>