Re: How to print column heading only in SQL plus

In article <26100634-3097-4ff5-80c9-c89ad4531a2f_at_googlegroups.com>, dhaya.snidhi_at_gmail.com says...
>
> Hi,
>
> I want print extra column heading in sqlplus. ( Signature )
>
> Eg:
>
> Code List
> ABC Bank
>
> Code Name Amount Signature
> --------- ----------------------- ----------- ------------
> 100 ABC 10.00
> 200 DEF 20.00
> 300 JKL 30.00
>
>
> I am unable to get the above result.
>
> SQL
>
> Column c1 format a10 Heading 'Code'
> Column n2 format a20 Heading 'Name'
> Column a1 format 99.99 Heading 'Amount'
> Column filler format a10 Heading 'Signature'
>
> Select code c1, name n1, amount a1
> from t1
>

try:

Select code c1, name n1, amount a1, null filler from t1;

-- 
jeremy