sqlplus -S user/pass@tns >/dev/null <<RAMONLC
set time off;
set echo off;
set head off;
set wrap off;
set linesize 10000;
set pagesize 0;
set trims on;
set feedback off;
set numwidth 50;
spool filename;
select * from table_name;
spool off;
exit
RAMONLC