Oracle Error Codes

missing left parenthesis

A required left parenthesis has been omitted. Certain commands, such as CREATE TABLE, CREATE CLUSTER, and INSERT, require a list of items enclosed in parentheses. Parentheses also are required around subqueries in WHERE clauses and in UPDATE table SET column = (SELECT…) statements.

How to Solve :

Correct the syntax, inserting a left parenthesis where required, and retry the statement.