Bases de Datos

Ratio: 4 / 5

ORA-00962: too many group-by / order-by expressions

Cause: The group-by or order-by column list contain more than 1000 expressions.

Action: Use 1000 or less expressions in the group-by or order-by list.

Ratio: 4 / 5

ORA-00964: table name not in FROM list

Cause: The table name referred in the select list is not specified in the from list.

Action: Make sure the name is correctly specified and matches one of the names in the from list.

Ratio: 4 / 5

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.

Ratio: 4 / 5

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.