title: Getting values blank from query using SQLPLUS but shell do not get it
body: <p>I'm doing this with sql plus:</p>
  
  <pre><code>set linesize 9999
  set trimspool on
  set feedback off
  set pagesize 0
  
  spool result.csv
  
  SELECT field1 || ';' || field2 || ';' || field3 || ';' || field4 || ';' || field5 || ';'   
  || field6 || ';' || field7 || ';' || field8  || ';' || field9  || ';' || field10
  FROM table
  WHERE field1 = '12345';
  </code></pre>
  
  <p>as you can see the result is:</p>
  
  <pre><code>x;x;x;x;x;x;x;x;;x
  </code></pre>
  
  <p>as you can see the field9 is blank in the database, so when I do:</p>
  
  <pre><code>while IFS=";" read -r field1 field2 field3 field4 field5 field6 field7 field8 field9 fiedl10
  do
  case "$field1" in
  
  1)
  echo "$field1"
  echo "$field2"
  echo "$field3"
  echo "$field4"
  echo "$field5"
  echo "$field6"
  echo "$field7"
  echo "$field8"
  echo "$field9"
  echo "$field10"
  </code></pre>
  
  <p>I'm not able to print the $field10. Not even $field9 which is blank but even $field10</p>
  
  <p>This is printing:</p>
  
  <pre><code>x &lt;-field1
  x &lt;-field2
  x &lt;-field3
  x &lt;-field4
  x &lt;-field5
  x &lt;-field6
  x &lt;-field7
  x &lt;-field8
  </code></pre>
  
  <p>Any idea would be helpful! Thanks!</p>