ORA-00928 missing SELECT keyword What causes an ORA-00928 error? A SELECT subquery must be included in a CREATE VIEW statement. How Xynomix can help Correct the syntax. Insert the required … Read more
ORA-00932 inconsistent datatypes: expected string got string What causes an ORA-00932 error? One of the following: An attempt was made to perform an operation on incompatible datatypes. For example, adding … Read more
ORA-00933 SQL command not properly ended What causes an ORA-00933 error? The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in … Read more
ORA-00934 group function is not allowed here What causes an ORA-00934 error? One of the group functions, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used in … 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
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-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-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-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-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
