Re: Compute in Oracle

[Quoted] 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
[Quoted]   5    71
PRINCIPAL1                          teach1            stud2          4
[Quoted]   3    75
PRINCIPAL1                         teach1 Average                   11
[Quoted] 8   72.73 [this one]
PRINCIPAL1                          teach2            stud1          9
  5   71
PRINCIPAL1                          teach2            stud2          3
  3   75
PRINCIPAL1                         teach2 Average                   12

here 72.73 and 66.67 etc are the values
Total co and su are dispayed using compute and avg should be calculated [Quoted] from these totals and displayed at the position shown.

Hopefully it helps Received on Tue Feb 22 2005 - 23:20:33 CET