title: Why is Oracle's to_char() function adding spaces?
body: <p>Why is Oracle's <code>to_char()</code> function adding spaces?</p>
  
  <pre><code>select length('012'), 
         length(to_char('012')), 
         length(to_char('12', '000')) 
    from dual;
  </code></pre>
  
  <p><code>3, 3, 4</code></p>