Re: How to print column heading only in SQL plus
Date: Thu, 12 Sep 2013 06:15:22 +0000 (UTC)
Message-ID: <pan.2013.09.12.06.15.22_at_gmail.com>
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.comReceived on Thu Sep 12 2013 - 08:15:22 CEST