OraFAQ Forum: Client Tools » Change seperator line of compute SUM or Count

Home » Other » Client Tools » Change seperator line of compute SUM or Count (Oracle 11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change seperator line of compute SUM or Count [message #589678]

Tue, 09 July 2013 23:57

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

Report message to a moderator

Re: Change seperator line of compute SUM or Count [message #589680 is a reply to message #589678]

Wed, 10 July 2013 00:19

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As far as I know, there is no parameter for this.

Regards
Michel

Report message to a moderator

Re: Change seperator line of compute SUM or Count [message #589681 is a reply to message #589678]

Wed, 10 July 2013 00:21

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Change seperator line of compute SUM or Count [message #589684 is a reply to message #589681]

Wed, 10 July 2013 00:29

aha613
Messages: 6
Registered: January 2011
Location: Sydney

Junior Member

Thanks Michel & Littlefoot, I also feel that my question is a little bit weird.

Report message to a moderator

Previous Topic:	plsql developer debuging
Next Topic:	SPA comparison report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 01:36:35 CST 2024