Monday, January 5, 2009

ORA-00936: missing expression

Error Description:
-------------------------------

Whenever you query or execute statement it fails with error,
Like,
SQL> select a|| from dual;
select a|| from dual
*
ERROR at line 1:
ORA-00936: missing expression

Cause of the Problem:
----------------------------------

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.

Solution of The Problem:
--------------------------------------

Check the syntax of the statement and check whether any operator/sign is added or any component is missing the statement. Like,
SQL> select 'a'|| from dual;
select 'a'|| from dual
*
ERROR at line 1:
ORA-00936: missing expression

Here after || there is something missing or || is redundant and hence ORA-936 arises.
SQL> select 'a'||'b' from dual;

'A
--
ab

No comments:

Post a Comment