Lab-verified fixes for Oracle Database errors
Every fix on this site was run on a real database: we reproduce the error, apply the fix, and re-run the statement. You see the actual output, not guesses.
SQL 14 errors
- ORA-00904 Oracle could not find a column with that name in the tables the query can see at that point.
- ORA-00918 In a join, a column name exists in more than one table and the query doesn't say which one.
- ORA-00936 Oracle expected a column, value or condition, but found nothing there.
- ORA-00937 An aggregate function (SUM, MAX, AVG...) is mixed with a plain column, and there is no GROUP BY.
- ORA-00942 Oracle could not find a table or view with that name that you are allowed to see.
- ORA-00955 You tried to create an object with a name that another object in the same schema already uses.
- ORA-00979 SELECT or ORDER BY uses a column that is neither in GROUP BY nor inside an aggregate function.
- ORA-01427 A subquery used where one value is expected returned two or more rows.
- ORA-01476 A division in the SQL or PL/SQL code had 0 as the divisor.
- ORA-03047 A number appears in a place where Oracle's grammar does not allow one.
- ORA-03048 A reserved word or symbol appears where the grammar does not allow it.
- ORA-03049 A word appears where Oracle's grammar does not allow anything new to start.
- ORA-04043 DESC or DROP could not find an object with that name in the place Oracle looked.
- ORA-30926 One target row matched more than one source row, so Oracle could not decide which value to write.
PL/SQL 4 errors
- ORA-01403 A PL/SQL SELECT INTO returned no row, or the code read a collection element that does not exist.
- ORA-01422 A PL/SQL SELECT INTO matched more than one row.
- ORA-04091 A row trigger or a function read or changed a table that the current statement is still modifying.
- ORA-06502 A PL/SQL variable could not hold the value assigned to it.
Constraints 4 errors
- ORA-00001 The row you tried to save has the same key value as a row that already exists.
- ORA-01400 An INSERT tried to put NULL into a column that is NOT NULL.
- ORA-02291 The foreign key value you inserted does not exist in the parent table.
- ORA-02292 You tried to delete or change a parent row that child rows still reference.
Privileges 2 errors
Space 2 errors
Locking 2 errors
Data types 6 errors
- ORA-00932 Two values that must have the same data type (a comparison, CASE branches, COALESCE arguments) have types Oracle will not convert between.
- ORA-01438 The number has more digits before the decimal point than the NUMBER(p,s) column allows.
- ORA-01722 Oracle tried to turn a string into a number and the string was not a valid number.
- ORA-01843 The part of the date string that should be the month could not be read as a month.
- ORA-01861 A date string has characters in places where the date format does not expect them.
- ORA-12899 The value is longer than the column's maximum length.
How we verify
Each scenario starts from fresh database users. A script runs the setup, confirms the exact error code, applies the fix and runs the statement again. The output shown is what the database printed, saved by the script.