title: Storing value with size greater than column size
body: <p>Need to discuss an approach: 
  We've a <strong>count</strong> column in oracle table. Dataype of column is <code>char(3 Byte)</code>. On each insertion of a row, the value of count column increment by 1(But it is not an identity column).</p>
  
  <p>There is a possibility that value will go beyond <strong>999</strong>. So how can we handle it.
  Till now, the approach I'm able to justified is:</p>
  
  <p>Increasing the column datatype at runtime. Steps are:</p>
  
  <ol>
  <li>First, we'll check the length of value.</li>
  <li>For eg, if length is 4 then Alter the column of table and change the size of column to <code>char(4 BYTE)</code></li>
  </ol>
  
  <p>Any better approach you people can provide...</p>