OraFAQ Forum: SQL & PL/SQL » SQLPLUS Column NEWLINE

Home » SQL & PL/SQL » SQL & PL/SQL » SQLPLUS Column NEWLINE

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

SQLPLUS Column NEWLINE [message #23873]

Fri, 10 January 2003 14:40

denny
Messages: 9
Registered: August 2002

Junior Member

Hello

Can the COLUMN column_name NEWLINE
be used in conjuntion with:
BREAK ON REPORT
Compute Sum Label 'Grand Totals' of count(B.D_AMOUNT)-
sum(B.D_AMOUNT) ON REPORT.

I cannot get a newline to print after each row.
Mgt wants a line spacing after each row.

If I use BREAK ON ROW skip 1 the COMPUTE does not
work because I then have to use COMPUTE....ON ROW.

any suggestions on how to get line spacing and compute
to work 'ON REPORT' would be most appreciated.

Report message to a moderator

Re: SQLPLUS Column NEWLINE [message #23935 is a reply to message #23873]

Wed, 15 January 2003 23:57

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

Put all of your break commands in one command, on one line, like:

BREAK ON ROW SKIP1 ON REPORT

The following quotation from Oracle on-line documentation explains why:

"Each BREAK command you enter replaces the previous one. Thus, if you want to use different spacing techniques in one report or insert space after the value changes in more than one ordered column, you must specify multiple columns and actions in a single BREAK command."

Report message to a moderator

Re: SQLPLUS Column NEWLINE [message #23948 is a reply to message #23935]

Thu, 16 January 2003 09:04

denny
Messages: 9
Registered: August 2002

Junior Member

thanks Barbara...it worked!

Report message to a moderator

Previous Topic:	TTITLE(old form)
Next Topic:	Insert carriage return into text fields.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 03 22:50:51 CDT 2025