Oracle DBA, How To, Error, Cause and Action

ORA-00976: Specified pseudocolumn or operator not allowed here.

ORA-00976: Specified pseudocolumn or operator not allowed here.


Cause:


LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or CONNECT_BY_ISCYCLE was specified at an illegal location.



Action:


Remove LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or CONNECT_BY_ISCYCLE.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)