ORA-00971 missing SET keyword What causes an ORA-00971 error? The keyword SET in an UPDATE statement is missing, misspelled, or misplaced. How Xynomix can help Check syntax and spelling, and … Read more
ORA-00969 missing ON keyword What causes an ORA-00969 error? The keyword ON in a GRANT, REVOKE, or CREATE INDEX statement was missing, misspelled, or misplaced. How Xynomix can help Check … Read more
ORA-00960 ambiguous column naming in select list What causes an ORA-00960 error? A column name in the order-by list matches more than one select list columns. How Xynomix can help … Read more
ORA-00957 duplicate column name What causes an ORA-00957 error? A column name was specified twice in a CREATE or INSERT statement. Column names must be unique within a table, view, … Read more
ORA-00955 name is already used by an existing object What causes an ORA-00955 error? An attempt was made to create a database object (such as a table, view, cluster, index, … Read more
ORA-00950 invalid DROP option What causes an ORA-00950 error? A DROP command was not followed by a valid DROP option, such as CLUSTER, DATABASE LINK, INDEX, ROLLBACK SEGMENT, SEQUENCE, SYNONYM, … Read more
ORA-00947 not enough values What causes an ORA-00947 error? This error occurs when a SQL statement requires two sets of values equal in number, but the second set contains fewer … Read more
ORA-00942 table or view does not exist What causes an ORA-00942 error? The table or view entered does not exist, a synonym that is not allowed here was used, or … Read more
ORA-00937 not a single-group group function What causes an ORA-00937 error? A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, … Read more
ORA-00936 missing expression What causes an ORA-00936 error? A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a … Read more
