Re: SQL PLUS...SHORT EASY QUESTION

DRathbun (drathbun_at_aol.com) wrote:
: In article <3rhshi$8hl_at_cville-srv.wam.umd.edu>, beefstew_at_wam.umd.edu (T.J.
: Klevinsky) writes:
 

: >I am using SQL Plus, The one problem I have is using Break and COmpute
: >statements. I'd like to use these commands without the lines they
: >create after the break or compute. Is there a way to turn off this
: >formatting?
 

: If I am understanding the question correctly, there is one possible
: solution. You can select the column you want to break on twice, format one
: as "noprint" and break on that one, while displaying the other. For
: example:
 

: break on bc1
: compute sum of sum_col on bc1
: column bc1 noprint
 

: Select break_col bc1, break_col bc2, sum_col
: from foo
 

: should print the columns bc2 and sum_col, with a sum below the sum_col,
: without the formatting (lines, etc). I didn't actually run this, but have
: used a trick like this in the past.
 

: Hope this helps!
 

: Dave Rathbun
: DRathbun_at_AOL.com

CTHanks for the help, I never thought of doing it that way. Wow, I guess sometimes you just have to take a step back to see where you are going.

T.J.
.

C
C
C
THanks for th: "This line is umop apisdn" Received on Tue Jun 13 1995 - 00:00:00 CEST