Existen varios SET que pueden configurar el SQL*Plus para dar formato a la salida de datos, por ejemplo:
Código:
C:\Temp>more 1.sql
set head off
set pages 0
set echo off
set feed off
set timi off
spool 1.lst
select * from dual
/
spool off
quit
C:\Temp>sqlplus oracle/oracle @1.sql
SQL*Plus: Release 10.2.0.3.0 - Production on Mar Ago 3 17:04:08 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Conectado a:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the OLAP and Data Mining options
X
Desconectado de Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the OLAP and Data Mining options
C:\Temp>more 1.lst
X
Saludos