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.