Re: SQL PLUS...SHORT EASY QUESTION

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

"This line is umop apisdn" Received on Mon Jun 12 1995 - 00:00:00 CEST