Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

Please help in resolving this

1 Solution

Accepted Solutions
suniljain
Honored Contributor

Re: SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

The options to resolve this Oracle error are: 
  1. 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 can correct the SELECT statement by including columns after the SELECT keyword. For example:

select supplier_id, supplier_name
from suppliers;

2 Replies
suniljain
Honored Contributor

Re: SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

The options to resolve this Oracle error are: 
  1. 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 can correct the SELECT statement by including columns after the SELECT keyword. For example:

select supplier_id, supplier_name
from suppliers;

Not applicable

Re: SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

Hi it may occur due to oracle connection issue also.

Community Browser