Home » SQL & PL/SQL » Client Tools » Change seperator line of compute SUM or Count (Oracle 11gR2)
icon5.gif  Change seperator line of compute SUM or Count [message #589678] Tue, 09 July 2013 23:57 Go to next message
aha613
Messages: 6
Registered: January 2011
Location: Sydney
Junior Member
Hi SqlPlus Guru,

Is that possible to modify the ***** and ----- in the TEXT report?

DEPARTMENT_ID JOB_ID     LAST_NAME                     SALARY
============= ========== ========================= ==========
           20 MK_MAN     Hartstein                      13000
************* **********                           ----------
sum                                                     13000


From above lines, you can see ****** and ----- which are above sum&13000.

Is that possible to change them as '='?
DEPARTMENT_ID JOB_ID     LAST_NAME                     SALARY
============= ========== ========================= ==========
           20 MK_MAN     Hartstein                      13000
============= ==========                           ==========
sum                                                     13000

"set underline =" is only shot the headers.

Thanks in advance.

Phil
Re: Change seperator line of compute SUM or Count [message #589680 is a reply to message #589678] Wed, 10 July 2013 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As far as I know, there is no parameter for this.

Regards
Michel
Re: Change seperator line of compute SUM or Count [message #589681 is a reply to message #589678] Wed, 10 July 2013 00:21 Go to previous messageGo to next message
Littlefoot
Messages: 19603
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea, I've never done that. However, note that SQL*Plus has rather limited report beautifying capabilities so - maybe you can't do that at all. But, if you choose one of GUI reporting tools (Oracle Reports, Crystal Reports, iReport and similar), your world will be suddenly resized from a nutshell to a watermelon.
Re: Change seperator line of compute SUM or Count [message #589684 is a reply to message #589681] Wed, 10 July 2013 00:29 Go to previous message
aha613
Messages: 6
Registered: January 2011
Location: Sydney
Junior Member
Thanks Michel & Littlefoot, I also feel that my question is a little bit weird.
Previous Topic: plsql developer debuging
Next Topic: SPA comparison report
Goto Forum:
  


Current Time: Tue Sep 16 23:01:56 CDT 2014

Total time taken to generate the page: 0.10690 seconds