ORA-01424 missing or illegal character following the escape character What causes an ORA-01424 error? The character following the escape character in LIKE pattern is missing or not one of the … Read more
ORA-01425 escape character must be character string of length 1 What causes an ORA-01425 error? Given escape character for LIKE is not a character string of length 1. How Xynomix … Read more
ORA-01427 single-row subquery returns more than one row What causes an ORA-01427 error? The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify … Read more
ORA-00972 identifier is too long What causes an ORA-00972 error? The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames. … Read more
ORA-01435 user does not exist What causes an ORA-01435 error? This message is caused by any reference to a non-existent user. For example, it occurs if a SELECT, GRANT, or … Read more
ORA-00975 date + date not allowed What causes an ORA-00975 error? An attempt was made to add two date fields together. Dates may be added only to numeric fields, not … Read more
ORA-01438 value larger than specified precision allows for this column What causes an ORA-01438 error? When inserting or updating records, a numeric value was entered that exceeded the precision defined … Read more
ORA-00979 not a GROUP BY expression What causes an ORA-00979 error? The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not … Read more
ORA-01455 converting column overflows integer datatype What causes an ORA-01455 error? The converted form of the specified expression was too large for the specified datatype. How Xynomix can help Define … Read more
ORA-00999 invalid view name What causes an ORA-00999 error? In a CREATE VIEW statement, the view name was missing or invalid. How Xynomix can help Enter a valid view name … Read more