Author: Dev

ORA-00978: nested group function without GROUP BY Oracle PL/SQL error message: ORA-00978: nested group function without GROUP BY. Cause: A group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used within another group function, as in MAX(COUNT(*)), without a corresponding GROUP BY clause. Solution: Either add a GROUP BY clause or…(Continue Reading)

ORA-00934: group function is not allowed here Oracle PL/SQL error message: ORA-00934: group function is not allowed here. Cause: One of the group functions, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used in a WHERE or GROUP BY clause. Solution: Remove the group function from the WHERE or GROUP BY clause.…(Continue Reading)

ORA-00924: missing BY keyword Oracle PL/SQL error message: ORA-00924: missing BY keyword Cause: The keyword BY was omitted in a GROUP BY, ORDER BY, or CONNECT BY clause. In a GRANT statement, the keyword IDENTIFIED must also be followed by the keyword BY. Solution: Correct the syntax. Insert the keyword BY where required and then…(Continue Reading)

ORA-00937: not a single-group group function Oracle PL/SQL error message: ORA-00937: not a single-group group function. Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause. Solution: Drop…(Continue Reading)

ORA-00971: missing SET keyword Oracle PL/SQL error message: ORA-00971: missing SET keyword. Cause: The keyword SET in an UPDATE statement is missing, misspelled, or misplaced. Solution: Check syntax and spelling, and use the keyword SET after the name of the table to be updated. Example: UPDATE students ADDRESS=’ABC No 1′ WHERE STUDENT_ID=1; Output: ORA-00971: missing…(Continue Reading)