how to eliminate blank line in sqlplus output
#!/bin/ksh
#Hi I am doing a data extract using sqlplus but the output has a blankline in it.
#How I ask sqlplus to not putting that blankline. Thanks so much for the kind help
mydate=`date '+%m%d%Y'`
file_ext=".txt"
file_hdr="testlinespace"
OUTFILE=`echo $file_hdr$mydate$file_ext`
echo $OUTFILE
mytime_start=`date '+%Y%m%d_%H%M%S'`
echo $mytime_start
sqlplus -silent /nolog << EOF
CONNECT scott/tiger@orc1.world
set echo off
set colsep ' '
set pagesize 0
set trimspool on
set headsep off
set linesize 100
set pagesize 50
set heading off
set feedback off
set timing off
set time off
set termout off
set headsep off
spool $OUTFILE
WITH a1 as
(
SELECT object_id,object_name from all_objects
)
SELECT * FROM a1 where rownum < 1001;
spool off
select to_char(sysdate,'YYYYMMDD_HH24MISS') from dual;
exit
$