connect oracle with sql server with a query

Question

hello , i'm trying to connect an oracle database with an sql server base withan oledb source by creation an select querry but i got this error msg

ora-00936 : missing expression

any idea please

thank you

Answer 1

Hi @asma gh ,

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.

ora-00936-missing-expression

Please check your query again to make sure the column and table name is correct.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.