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，

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.