|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 96 of 177
"Analytic Functions" for information on syntax, semantics, and restrictions
RATIO_TO_REPORT is an analytic function. It computes the ratio of a value to the sum of a set of values. If
expr evaluates to null, then the ratio-to-report value also evaluates to null.
The set of values is determined by the
query_partition_clause. If you omit that clause, then the ratio-to-report is computed over all rows returned by the query.
You cannot use
RATIO_TO_REPORT or any other analytic function for
expr. That is, you can use other built-in function expressions for
expr, but you cannot nest analytic functions.
"About SQL Expressions" for information on valid forms of
The following example calculates the ratio-to-report value of each purchasing clerk's salary to the total of all purchasing clerks' salaries: