Oracle errors
Plain explanations of the errors learners meet most often in Oracle SQL, each with its cause and the fix.
ORA-00001Unique constraint violatedORA-00904Invalid identifierORA-00905Missing keywordORA-00907Missing right parenthesisORA-00913Too many valuesORA-00918Column ambiguously definedORA-00920Invalid relational operatorORA-00923FROM keyword not found where expectedORA-00927Missing equal signORA-00932Inconsistent data typesORA-00933SQL command not properly endedORA-00934Group function is not allowed hereORA-00936Missing expressionORA-00937Not a single-group group functionORA-00942Table or view does not existORA-00947Not enough valuesORA-00955Name is already used by an existing objectORA-00957Duplicate column nameORA-00979Not a GROUP BY expressionORA-00980Synonym translation is no longer validORA-00998Must name this expression with a column aliasORA-01031Insufficient privilegesORA-01086Savepoint never establishedORA-01400Cannot insert NULLORA-01407Cannot update to NULLORA-01427Single-row subquery returns more than one rowORA-01430Column being added already exists in tableORA-01438Value larger than specified precision allowed for this columnORA-01439Column to be modified must be empty to change data typeORA-01441Cannot decrease column length because some value is too bigORA-01468A predicate may reference only one outer-joined tableORA-01476Divisor is equal to zeroORA-01722Invalid numberORA-01732Data manipulation operation not legal on this viewORA-01733Virtual column not allowed hereORA-01735Invalid ALTER TABLE optionORA-01756Quoted string not properly terminatedORA-01779Cannot modify a column which maps to a non key-preserved tableORA-01789Query block has incorrect number of result columnsORA-01790Expression must have same data type as corresponding expressionORA-01830Date format picture ends before converting entire input stringORA-01839Date not valid for month specifiedORA-01843Not a valid monthORA-01847Day of month must be between 1 and last day of monthORA-01858A non-numeric character was found where a numeric was expectedORA-01861Literal does not match format stringORA-02260Table can have only one primary keyORA-02264Name already used by an existing constraintORA-02266Unique/primary keys in table referenced by enabled foreign keysORA-02270No matching unique or primary key for this column listORA-02287Sequence number not allowed hereORA-02290Check constraint violatedORA-02291Integrity constraint violated - parent key not foundORA-02292Integrity constraint violated - child record foundORA-02449Unique/primary keys in table referenced by foreign keysORA-08002Sequence CURRVAL is not yet defined in this sessionORA-12899Value too large for columnORA-25154Column part of USING clause cannot have qualifierORA-25155Column used in NATURAL join cannot have qualifierORA-25156Old style outer join (+) cannot be used with ANSI joinsORA-25556(+) with an OR operand that lacks itORA-28221REPLACE not specifiedORA-30076Invalid extract field for extract sourceORA-38104Columns referenced in the ON clause cannot be updated