select ... as LINE
from ...

sqlplus ... <<EOF > /dev/null
set linesize 1000
set pagesize 0
set term off
set echo off
set head off
column LINE heading '' format a200
spool result.txt
select ... as LINE
from ...;
spool off
exit
EOF

sqlplus -S usr/pwd@//server:port/db <<EOF > /dev/null
set SQLPROMPT ''
set SQLNUMBER off
set ESCAPE '\'
set ECHO off
set VERIFY off
set SERVEROUTPUT off
set TERM off
set TERMOUT off
set HEADING off
set HEAD off
set FEEDBACK off
set FEED off
set WRAP off
set TRIMOUT on
set TRIMSPOOL on
set PAGESIZE 0
set LINESIZE 0
set PAGES 0

spool sessions.txt
<sql-запрос>;
spool off

exit
EOF