title: <SQL>How to change the size of VARCHAR2 of the table
body: <p>I googled it enough but for some reason, mine doesnt work.</p>
  
  <p>the column name is <strong>CD</strong>. type is <strong>VARCHAR2(10Byte)</strong> </p>
  
  <p>Table name is <strong>TB_POT_ECD_CD</strong></p>
  
  <p>I want to change the size of column to <strong>VARCHAR2(100Byte)</strong></p>
  
  <pre><code>ALTER TABLE TB_POT_ECD_CD MODIFY(CD VARCHAR2(100))
  </code></pre>
  
  <p>didn't work. Can anyone look at it?</p>