title: SQLPLUS - ORACLE 12 - Trim extra columns white space
body: <p>I've a problem with a sqlplus spool (oracle 12c/18c).
  I want trim extra white space in columns.</p>
  
  <p>This is the expected result</p>
  
  <pre><code>01JHON BROWN  30RED    
  02MARIO ROSSI 25WHITE  
  </code></pre>
  
  <p>this is my result</p>
  
  <pre><code>01    JHON BROWN       30        RED         
  02    MARIO ROSSI      25        WHITE    
  </code></pre>
  
  <p>this is the sql code</p>
  
  <pre><code>SET ECHO OFF
  SET VERIFY OFF
  SET FEEDBACK OFF
  SET SERVEROUTPUT ON
  SET HEADING OFF
  SET PAGESIZE 0 
  SET LINESIZE 2000
  SET SQLBLANKLINES ON
  SET FEEDBACK OFF
  SET TIME OFF
  SET TIMING OFF
  SET COLSEP ''
  SET TRIMSPOOL OFF
  SET TERMOUT OFF
  
  ALTER SESSION SET NLS_DATE_FORMAT='YYYYMMDD';
  ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.,';
  
  spool pippo.txt
  
  SELECT TRIM(NUM), RPAD(NAME,12), TRIM(AGE), RPAD(COLOR,7)
  FROM PLUTO;
  
  spool off
  exit
  </code></pre>
  
  <p>THX</p>