Oracle/PLSQL: ORA-00936 Error

Error:

ORA-00936: missing expression

Cause:

You tried to execute an SQL statement but you omitted a part of the syntax.

Action:

The options to resolve this Oracle error are:

This error most commonly occurs when you try to execute a SELECT statement and forget to the list of the columns in the SELECT statement.

For example, you tried to execute the following SELECT statement:

select
from suppliers;

You would receive the following error message:

You can correct the SELECT statement by including columns after the SELECT keyword. For example:

select supplier_id, supplier_name
from suppliers;