How to concatenate two lines of result from sqlplus

TABLE: USER USER_NAME NUMBER ADDRESS

dennis ritchie  123456          att bell lab
ken thomas      234567          att bell lab

I select the content in korn shell as following:

#...

sqlplus -silent ""$user"/"$pass"_at_"$db_ins"" <<-EOF set feed off
set heading off
spool $output # variables assigned somewhere already

select USER_NAME, NUMBER, ADDRESS
from USER

spool off
exit
EOF
#...

My question is, I get the result in the $output file as,

dennis ritchie

123456 att bell lab

How can I concatenate two lines above? Or how can I place the line 123456 att bell lab after dennis ritchie? Received on Mon Nov 06 2006 - 07:22:15 CET