set echo off set heading off set termout off set pause off set pagesize 0 set linesize 300 set feedback 80 set colsep ',' spool c:\temp\test.log select * from test_table order by aaa,bbb; spool off