title: How to trim trailing spaces before the column value in SQL plus
body: <p>I am trying to export the sql select query values to .txt format file through sql plus. In the generated output file trailing spaces are appearing before the first column values.</p>
  <p><a href="https://i.stack.imgur.com/Si8WL.png" rel="nofollow noreferrer">Attached is the image which contains the data displayed in SQL plus and how it is displayed in the text file</a></p>
  <p>Below is the query I have tried to use.</p>
  <pre><code>SET UNDERLINE OFF;
  SET PAGESIZE 0;
  set feedback off;
  SELECT EMPNO,ENAME,JOB,MGR FROM emp;
  </code></pre>
  <p>Can anyone suggest how to remove the trailing spaces before the first column values in SQL plus.</p>