Oracle Error : ORA-00936: missing expression

Many of you would have faced this error while executing a SQL Query. Below are the details on this error.

missing expression

A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.

The common reasons for this error are:
  1. You tried to assign a value to a numeric variable, but the value is larger than the variable can handle.
  2. You tried to assign a non-numeric value to a numeric variable and caused a conversion error.

Check the statement syntax and specify the missing component.

Example :

Oracle PLSQL

if you notice in the above SELECT statement there is extra comma after STUDENT_NAME due to which this error occured.