Author: Dev

ORA-00925: missing INTO keyword Oracle PL/SQL error message: ORA-00925: missing INTO keyword. Cause: The INSERT statement has been entered without the keyword INTO. Solution: On the INSERT statement add the keyword INTO and then retry the statement. Example: Insert COURSE (COURSE_ID,NAME,DESCRIPTION,DURATION,PRICE) values (6,’Java’,’Java course 1′,’12 weeks’,200); Output: ORA-00925: missing INTO keyword Correct: Insert INTO COURSE…(Continue Reading)

ORA-00908: missing NULL keyword Oracle PL/SQL error message: ORA-00908: missing NULL keyword. Cause: Either of the following: In a CREATE TABLE or ALTER TABLE statement, NOT was entered to specify that no null values are allowed in that column, but the keyword NULL was omitted. In the IS [NOT] NULL logical operator, the keyword NULL…(Continue Reading)

Oracle PL/SQL error message: ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes. This error indicates that a buffer overflow has occurred, and the size of the data being processed has exceeded the predefined limit of 20000 bytes. Cause: The stored procedure ‘raise_application_error’ was called which causes this error to be generated. Let’s break down the…(Continue Reading)

ORA-00979: not a GROUP BY expression Oracle PL/SQL error message: ORA-00979: not a GROUP BY expression. Cause: The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not included in a group function(like AVG, COUNT, MAX, MIN, SUM, STDDEV or VARIANCE) must be listed in the GROUP…(Continue Reading)

Error Messages ORA-00001: unique constraint violated ORA-00904: invalid identifier ORA-00905: missing keyword ORA-00908: missing NULL keyword ORA-00922: missing or invalid option ORA-00924: missing BY keyword ORA-00925: missing INTO keyword ORA-00934: group function is not allowed here ORA-00937: not a single-group group function ORA-00942: table or view does not exist ORA-00947: not enough values ORA-00955: name…(Continue Reading)