Database Error Messages

ORA-30485

missing ORDER BY expression in the window specification

Cause

Either the ORDER BY expression is mandatory for this function, or there is an aggregation group without any ORDER by expression.