Statements Oracle cannot parse, and GROUP BY and subquery rules.
ORA-00907
missing right parenthesisA bracket is missing, or the brackets contain a word Oracle does not accept.
ORA-00911
invalid characterA symbol in an unquoted name, a trailing semicolon from code, or pasted curly quotes.
ORA-00933
SQL command not properly endedExtra or unsupported text after a complete statement, such as LIMIT.
ORA-00936
missing expressionA required value or expression is missing, often a comma before FROM.
ORA-00937
not a single-group group functionA group function is mixed with a plain column and there is no GROUP BY.
ORA-00979
not a GROUP BY expressionA SELECT, HAVING or ORDER BY expression is not in the GROUP BY clause or an aggregate.
ORA-01427
single-row subquery returns more than one rowA subquery used as a single value returned several rows.
No errors in this category match your search. Search the whole library.