ORA-30486: invalid window aggregation group in the window specification
Cause: If the windowspecification is specified using RANGE option and there are
multiple ORDER BY expressions, then the aggregation group cannot contain any
expression (It can only have CURRENT ROW, UNBOUNDED PRECEDING, or
18-68 Oracle Database ErrorMessages
UNBOUNDED FOLLOWING).First end point (bound) cannot be UNBOUNDED
FOLLOWING and second end point cannot be UNBOUNDED PRECEDING. If the
first end point is CURRENT ROW, then second end point can only be CURRENT
ROW or <expr> /UNBOUNDED FOLLOWING. If the first end point is<expr>
FOLLOWING, then second end point can only be <expr>/UNBOUNDED
FOLLOWING.
Action: None
|