All Oracle Error CodesOracle DBA Forum

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.