ORA-30486: invalid window aggregation group in the window
specification



ORA-30486: invalid window aggregation group in the window specification..

Answer / guest

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 <expr>
/UNBOUNDED FOLLOWING. If the first end point is <expr>
FOLLOWING, then second end point can only be
<expr>/UNBOUNDED FOLLOWING.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27461: The value for attribute string is too large.

1 Answers  


ORA-06518: PL/SQL: Probe version string incompatible with version string

1 Answers  


RMAN-06193: connected to target database (not started)

3 Answers  


ORA-07234: slemcw: fseek error.

1 Answers  


CLSR-00518: Failed to register a preconnect service name

1 Answers  


ORA-13802: failed to purge SQL Tuning Base entry from sql$

1 Answers  


ORA-02228: duplicate SIZE specification

1 Answers  


ORA-02853: Invalid server list latch time out value

1 Answers  


TNS-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


ORA-29265: HTTP header not found

1 Answers  


DRG-12219: section name missing

1 Answers  


ORA-13799: threshold not found

1 Answers  


Categories