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
Monday, January 5, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment