Blog

ORA-00936 error

Question: When trying to use the SQL below, I keep getting the ORA-00936 error. What is the problem?

select from customer where cust_name = 'IBM';

How do I address this ORA-00936 error?

Answer: The Oracle oerr utility notes this about the ORA-00936 error:

ORA-00936 missing expression

Cause:

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.

Action:

Check the statement syntax and specify the missing component.

The ORA-00936 happens most frequently:

1 - When you forget list of the column names in your SELECT statement.

2. When you omit the FROM clause of the SQL statement.

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.