title: What is the major difference between Varchar2 and char
body: <p><strong>Creating Table:</strong></p>
  
  <pre><code>CREATE TABLE test (
  charcol    CHAR(10),
  varcharcol VARCHAR2(10));
  
  SELECT LENGTH(charcol), LENGTH(varcharcol) FROM test;
  </code></pre>
  
  <p><strong>Result:</strong></p>
  
  <pre><code>LENGTH(CHARCOL) LENGTH(VARCHARCOL)
  --------------- ------------------
               10                  1 
  </code></pre>
  
  <p>Please Let me know what is the difference between Varchar2 and char?
  At what times we use both?</p>