remove blank lines from csv using shell script for oracle
<p>Hi am using following shell script to create csv from oracle database</p>

<pre><code>export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export PATH=$PATH:$ORACLE_HOME/bin
sqlplus -s user1/user1&lt;&lt;!
Spool on
set heading off
SET FEEDBACK OFF
set wrap off
set colsep ,
SET LINESIZE 200
set trims on
Spool /home/ist/username.csv
select 'username','userid' from dual;
select username,userid from users;
Spool off
EXIT
!
</code></pre>

<p>I am getting following output</p>

<p><a href="https://i.stack.imgur.com/g7aZ0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/g7aZ0.png" alt="enter image description here"></a></p>

<p>as you can see there is blank line at first and third row
but am expecting file without blank lines.
Any help will be appreciated.</p>