Why does my spool write each record seperate line

[Tison]

Why does this write each record on a separate line ?
(note; only a small sample of actual script)
sqlplus -S id/pass@sid << EOT >>/dev/null
set heading off
set pagesize 0
set linesize 132
set serveroutput off
set verify off
set feedback off
spool fileout
select vendor_name , vendor_alt
from vendors
order by 1
spool off

I can get all on 1 line if i use || but then I cannot use order by clause.

 

[sem]

1. You may sort by columns not in your query:

select vendor_name || vendor_alt
from vendors
order by vendor_name

2. set linesize 132 is probably not enough for both fields and a delimiter between columns (you meant columns not records, didn't you?)

Regards, Dima

http://seminihin.narod.ru