---
title: "ORA-00907: missing right parenthesis/?"  
description: "ORA-00907: missing right parenthesis/?"  
author: "Utpal Vishwas"  
published: 2023-07-17  
updated: 2023-07-18  
canonical: https://www.mindstick.com/forum/159135/ora-00907-missing-right-parenthesis  
category: "mssql server"  
tags: ["database", "sqlexception", "error", "oracle"]  
reading_time: 1 minute  

---

# ORA-00907: missing right parenthesis/?

ORA-00907: [missing](https://answers.mindstick.com/qa/52138/international-missing-children-s-day-2019-was-observed-on) [right](https://www.mindstick.com/articles/12766/check-whether-you-are-doing-digital-transformation-right-or-not) parenthesis/?

## Replies

### Reply by Aryan Kumar

Oracle error `ORA-00907: missing parenthesis` occurs when a SQL statement is missing a parenthesis. This can happen for a variety of reasons, such as:

- The parenthesis was accidentally deleted.
- The parenthesis was not closed correctly.
- The parenthesis was not matched correctly.

To fix `ORA-00907: missing parenthesis`, you need to find the missing parenthesis and add it to the SQL statement. You can use a text editor to search for the missing parenthesis, or you can use a SQL debugging tool to help you find the error.

Here are some examples of how to fix `ORA-00907: missing parenthesis`:

SQL

```plaintext
-- This statement will cause an error because the parenthesis is missing.
SELECT * FROM table1 WHERE id = 1;

-- This statement will fix the error by adding the missing parenthesis.
SELECT * FROM table1 WHERE id = (1);
```

If you are still getting `ORA-00907: missing parenthesis` after you have added the missing parenthesis, then you may have a more complex problem. In this case, you may need to use a SQL debugging tool to help you find the error.


---

Original Source: https://www.mindstick.com/forum/159135/ora-00907-missing-right-parenthesis

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.