ORA-00976: LEVEL- PRIOR- or ROWNUM not allowed here

ORA-00976: LEVEL- PRIOR- or ROWNUM not allowed here
Cause: LEVEL, PRIOR, or ROWNUM is being specified at illegal location.

Action: Remove LEVEL, PRIOR, or ROWNUM.