Stack Overflow
Stack Overflow

Questions tagged [ora-00907]

Missing right parenthesis: a left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses.

Missing right parenthesis: 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.

91 questions
25
votes
4 answers

ORA-00907: missing right parenthesis

I have been looking at this code for the past two days now and I can not seem to get it to work. It keeps giving me ORA-00907: missing right parenthesis. I know that this is a topic that comes up a lot but for some reason none of the examples I…
user3806509
  • 267
  • 1
  • 3
  • 3
14
votes
3 answers

ORA-00907 Missing right parenthesis issue - select with order by inside insert query

I am trying to do insert to a table and it uses one select statement for one column. Below is the illustration of my query. INSERT INTO MY_TBL (MY_COL1, MY_COL2) VALUES ( (SELECT DATA FROM FIR_TABL WHERE ID = 1 AND ROWNUM = 1 ORDER BY CREATED_ON…
Vaandu
  • 4,857
  • 12
  • 49
  • 75
11
votes
3 answers

Why does Oracle think I'm missing a right parenthesis?

In Oracle 10i, I'm running the following command: ALTER TABLE jnrvwchnglst ADD ( jnrvwchnglst_userid NUMBER(10) NOT NULL DEFAULT 1 ) Yes jnrvwchnglst is an existing table and no jnrvwchnglst_userid is not an existing column. The Oracle error…
Jason Cohen
  • 81,399
  • 26
  • 107
  • 114
8
votes
4 answers

ORA-00907: missing right parenthesis Error while creating a table?

I am new to oracle, I have created two tables using following queries, CREATE TABLE employee ( emp_name VARCHAR(20) NOT NULL, street VARCHAR(50) NOT NULL, city VARCHAR(20) NOT NULL, PRIMARY KEY(emp_name) ) and CREATE TABLE company ( comp_name…
Nina
  • 103
  • 2
  • 2
  • 5
7
votes
2 answers

Foreign Keys and Primary Keys at the same time

I am trying to create table (orderdetails2); the table has two FKs and a PKs on the two FK columns. Here is my code: Version 1 create table OrderDetails2 ( PFOrder_ID Number(3) FOREIGN KEY REFERENCES Orderr(Order_ID), PFProduct_ID Number(3)…
Bader
  • 207
  • 1
  • 8
  • 21
7
votes
1 answer

UNION on two select gives 'SQL Error: ORA-00907: missing right parenthesis'

I'm trying to UNION the results of two queries. But I'm getting the following error: Error at Command Line:9 Column:81 Error report: SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" Here's my query: SELECT…
jai
  • 21,519
  • 31
  • 89
  • 120
5
votes
1 answer

(Yet another) "Missing Right Parenthesis"

I am using 10g, and am trying to do some simple calculation and then save the result in a column. The actual tables have many more columns, but here are the what I am using in my query: CREATE TABLE "VACCINE_LOT" ( "VACCINE_LOT_ID" NUMBER(10,0)…
Hua
  • 666
  • 2
  • 9
  • 21
5
votes
1 answer

ORA-00907: missing right parenthesis

CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), PRIMARY KEY (P_Id) ) CREATE TABLE Orders ( O_Id int NOT NULL PRIMARY KEY, OrderNo int NOT NULL, P_Id int FOREIGN KEY REFERENCES…
user663724
5
votes
2 answers

In Oracle (pre-11.2): When using cast(collect(...)), how do I order the result?

When using cast(collect(...)), how do I order the result? I have a function called GetStringForTable, defined like this: FUNCTION GetStringForTable(vTable in TVarCharTable, vDelimeter in varchar default ',') return VarChar2 is aResult…
Svein Bringsli
  • 5,640
  • 7
  • 41
  • 73
3
votes
1 answer

Oracle query getting ORA-00907: missing right parenthesis

I've read through the other missing right parenthesis questions and haven't found an answer to my problem. I assume it is a syntax error cutting things off before the end (I'm not really an Oracle guy) but I don't know where it is. The query is…
monkeypushbutton
  • 196
  • 1
  • 9
  • 21
3
votes
1 answer

SQL Syntax Error: "Missing Right Parenthesis"

I understand the ORA-00907 is indicating that I have a syntax error in my code, I just can't find it. Can someone help point out the problem? I'm using SQL Developer (Oracle12c). CREATE TABLE equip (equipid NUMBER(3), edesc VARCHAR2(30), …
Andrew Biddle
  • 111
  • 8
3
votes
1 answer

Oracle: Use of notational parameters which calling functions in insert statements not allowed?

Why does Oracle 10 R2 not allow use of notational parameters while calling functions in insert statements ? In my app, I'm calling a function in an insert statement. If use notational method of parameter passing, I get an ORA-00907: Missing right…
Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
3
votes
2 answers

Entity framework Left Outer Joins and Group into throws : ORA-00907: missing right parenthesis

I am using Entity framework in a data access based on Entity Framework to target multiple database. we are a team working with Entity Framework, for 2 years now, and the code produced works perfectly with sql server 2008. Now, we are testing the…
a.boussema
  • 1,096
  • 11
  • 19
2
votes
1 answer

ORA-00907 when dynamically creating a view in PL/SQL and using a CLOB

This is one of those situations where you get an unhelpful error message back from Oracle. My situation is as follows: I'm dynamically creating a view in PL/SQL. I build a string and use EXECUTE IMMEDIATE to create the view. The string is so long…
TrojanName
  • 4,853
  • 5
  • 29
  • 41
2
votes
1 answer

ORA-00907 when trying to create a CHECK constraint

I need your help with this error: ORA-00907 on Check CONSTRAINT Query: CREATE TABLE S_NEWS.T_UTILISATEUR_USR ( USR_ID INTEGER NOT NULL PRIMARY KEY, USR_MAIL VARCHAR(256) NOT NULL, USR_TITRE …
Aubin
  • 21
  • 1
1
2 3 4 5 6 7