ORA-30486: invalid window aggregation group in the window specification
Cause: If the window specification 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 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 lamp;lt;lamp;nbsp;exprlamp;gt; or UNBOUNDED FOLLOWING. If the first end point is lamp;lt;lamp;nbsp;exprlamp;gt; FOLLOWING, then second end point can only be lamp;lt;lamp;nbsp;exprlamp;gt; or UNBOUNDED FOLLOWING.
Action: none
Cause: If the window specification 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 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 lamp;lt;lamp;nbsp;exprlamp;gt; or UNBOUNDED FOLLOWING. If the first end point is lamp;lt;lamp;nbsp;exprlamp;gt; FOLLOWING, then second end point can only be lamp;lt;lamp;nbsp;exprlamp;gt; or UNBOUNDED FOLLOWING.
Action: none
No comments:
Post a Comment