|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Expressions, 4 of 14
A compound expression specifies a combination of other expressions.
You can use any built-in function as an expression ("Function Expressions"). However, in a compound expression, some combinations of functions are inappropriate and are rejected. For example, the
PRIOR operator is used in
BY clauses of hierarchical queries.
Some valid compound expressions are: