Re: How to print column heading only in SQL plus

On Sat, 07 Sep 2013 01:05:30 -0700, sdhaya wrote:

> 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
>
> In the above sql, signature is not getting printed.
>
> please help..
>
> Dhaya

sqlplus is not a reporting tool. For a simple report like this, try with Perl. If you need something more complex, there are things like Pentaho, Jasper, OpenReports or RLIB. I like RLIB because it has bindings for both Perl and PHP, despite the fact that it is the least popular of the listed tools.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com