title: A useful example of when to use vsize function instead of length function in Oracle?
body: <p>It seems vsize() and length() return the same results.  Does anyone know of a practical example of when to use vsize instead of length?</p>
  
  <pre><code>select vsize(object_name), length(object_name) from user_objects
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>/468ba408_LDAPHelper    20  20
  /de807749_LDAPHelper    20  20
  A4201_A4201_UK  14  14
  A4201_PGM_FK_I  14  14
  A4201_PHC_FK_I  14  14
  </code></pre>