title: SQL Plus/Shell Script: Extra newline printed
body: <p>Below is my variable and the value is being fetched from the query.</p>
  
  <pre><code>subsno=`sqlplus -s user/pass@DB &lt;&lt; EOL
  set heading off;
  SET FEEDBACK OFF;
  
  select CFR_SUBSCRIBER_NO
  from csm_future_request
  where CFR_BAN = 111111111 and cfr_status = 'E' and CFR_SUBSCRIBER_NO&lt;&gt;0000000000;
  
  EOL`
  </code></pre>
  
  <p>But when I am printing this variable it is being printed with a newline first. And the ${#subsno} is printing (length+1), i.e, it is including the new line character.</p>
  
  <p>Is there any option to stop the new line from being printed ? I have already check the table, it has proper data.</p>