SQL> set linesize 1000
SQL> set wrap off
SQL> set heading off
SQL> spool foo.txt
SQL> select * from leadsin where rownum < 4;

6309069623 MALISKA BRUCE 973 WELLINGTON CIR AURORA IL 60506 0 0
6309069769 WILLIAMS CLIFFORD 130 TEALWOOD RD MONTGOMERY IL 60538 0 0
6309069982 CONNELLY JOHN 130 S HANKES RD AURORA IL 60506 0 0

Still not working......