Author: Dev

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)

ORA-06550: PLS-00428: an INTO clause is expected in this SELECT statement Oracle PL/SQL error message: ORA-06550: PLS-00428: an INTO clause is expected in this SELECT statement. Cause: A SELECT statement was executed without INTO clause in a PL/SQL block. Solution: Add the INTO clause to the SELECT statement. Example: DECLARE v_full_name VARCHAR2(500); BEGIN SELECT FIRST_NAME…(Continue Reading)