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