ORA-00907: missing right parenthesis

Hi,

I got ” ORA-00907: missing right parenthesis ” error in Oracle SQL ( Table create, DML and DDL operations ) .

 

Details of error are as follows.

 

SQL> create table test(id number;
create table test(id number
*
ERROR at line 1:
ORA-00907: missing right parenthesis

ORA-00907 missing right parenthesis

Cause: A left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses. All parentheses must be entered in pairs.

Action: Correct the syntax and retry the statement.

 

 

When you write queries in Oracle SQL, left parenthesis (the “(” character) must be paired with a right parenthesis character (the “)” character).

If you use more left parentheses than right parentheses, then you will get this error.

ORA-00907 Errors are seen in CREATE TABLE, CREATE CLUSTER, and INSERT commands or within subqueries such as WHERE clauses, UPDATE table SET column = (SELECT…) statements  which all require an itemized list enclosed in parentheses.

 

To solve this error, add the right parenthesis, it will be solved as follows.

SQL> create table test(id number;
create table test(id number
*
ERROR at line 1:
ORA-00907: missing right parenthesis


SQL> create table test(id number);

Table created.

SQL>

 

 

 

Do you want to learn Oracle SQL, then read the following articles.

Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course