Re: Compute in Oracle

Can anyone please help in displaying the value that I have mentioned below in sql plus reports..

very urgent.. due dte approaching
maya wrote:
> Yes, with Oracle 9i and using sqlplus reports
>
> and we use sqlplus compute/break commands
>
> as an example:
>
> Principal Teacher Name STUDNAME co' su'
> Percent
> ----------- -------------- ------------
> -------- --- --- ---
> PRINCIPAL1 teach1 stud1
7
> 5 71
> PRINCIPAL1 teach1 stud2
4
> 3 75
> PRINCIPAL1 teach1 Average
11
> 8 72.73 [this one]
> PRINCIPAL1 teach2 stud1
9
> 5 71
> PRINCIPAL1 teach2 stud2
3
> 3 75
> PRINCIPAL1 teach2 Average
12
> 8 66.67 [this one]
>
> here 72.73 and 66.67 etc are the values
> Total co and su are dispayed using compute and avg should be
calculated
> from these totals and displayed at the position shown.
>
> Hopefully it helps
Received on Wed Feb 23 2005 - 15:26:18 CET