Re: sql*plus reports

Also, Make sure the ORDER BY clause of your select statement match the order you specify in the break command.

Martin Cookson

Suresh Bhat wrote in message <01be719d$e27560a0$a504fa80_at_mndnet>...
>You normally would say something like
>
>break on column1 skip 3 on column2 skip 1 on column3 skip page
>
>where column1, column2 etc can be actual column names or aliases
>
>
>If you are computing sum, avg etc. then you have to break on the columns
>that you want sum for:
>
>break on x2 skip page on sorter skip 3
>compute sum of mcf on sorter
>compute sum of mcf on report
>compute sum of mcf on x2
>compute sum of mmbtus on sorter
>compute sum of mmbtus on report
>compute sum of mmbtus on x2
>
>The key here is you BREAK ON the same column aliases that you have COMPUTE
>ON.
>
>hth
>
>Suresh
>
>Deepak rajan <venkatesan.sounderarajan_at_pharma.novartis.com> wrote in
>article <36F11DC2.B8FE99DA_at_pharma.novartis.com>...
>> Hi
>>
>> could anyone explain how the break command works while generating a
>> sql*plus report. I am having difficulty in breaking the columns to
>> provide info. as the column values repeat again though I put a break on
>> command for that column. Does anyone know the reason? Thanks for
>> your assistance in advance
>>
>> Regards
>> Deepak
>>
>>
Received on Sat Mar 20 1999 - 04:12:03 CET