title: Remove last character from string in sql plus
body: <p>I'm trying to remove the last character from a column output in sql plus. The length of the column entries is not fixed</p>
  
  <p>For e.g XYZA should output as XYZ</p>
  
  <p>I've tried using the <code>substr()</code> function but it doesn't seem to work.</p>
  
  <pre><code>SUBSTR(ooo.CO_NAME,1,LENGTH(ooo.CO_NAME-1))
  </code></pre>