Oracle Message ORA-00976 - LEVEL, PRIOR, or ROWNUM not allowed here

ERROR	LEVEL, PRIOR, or ROWNUM not allowed here
CAUSE	LEVEL, PRIOR, or ROWNUM is being specified at illegal location.
ACTION	Remove LEVEL, PRIOR, or ROWNUM.