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

Oracle error

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.

See more oracle error here.

oracle error- ORA-00972: identifier is too long

Oracle error

ORA-00972: identifier is too long

Cause: An identifier with more than 30 characters was specified.

Action: Specify at most 30 characters.

See more oracle error here.

oracle error- ORA-00965: column aliases not allowed for '*'

Oracle error

ORA-00965: column aliases not allowed for '*'

Cause: The statement is trying to alias the * expression in the select list which is not legal.

Action: Remove the alias.

See more oracle error here.