Re: SqlPlus headers

Paul,

Another solution is:

set heading off
set trimspool off
set pagesize 0
set feed off
set echo off
set termout off
spool result.lis
select 'column1','column2','column3' from dual; select col1,col2,col3 from heading_test; spool off
exit

Ivan

On Fri, 18 Nov 2005 12:00:07 +0100, Peter van Rijn wrote:

>> of the application (which cannot be changed).
>>
>> Please can anybody tell me how to get the header to show the full alias
>> and not be truncated to the length of the field?
>>
>> Many Thanks in advance.
>>
>> Paul
>>
>>

> SQL> COLUMN alias1 FORMAT <xxx>
> 
> where <xxx> depends on the datatype.
> 
> See the SQL*Plus User Guide for more info.
> 
> regards
> Peter