Missing Parenthesis in Apex

Question

I'm trying to write a script in Apex to create multiple tables. The first table is created with no issues but every table after that one gives me a missing parenthesis issue. Sometimes it's the left, sometimes it's the right. I've tried everything with no avail.

I have debugged it numerous times, spoken with the others and have not found the solution.

Create Table Employee -- Creates Employee table and references it to ProjDept table ( EmployeeID Number(4) Not Null, FirstName VarChar2(15) Not Null, LastName VarChar2(20) Not Null, ProjDeptID Number(4) Not Null, PhoneNumber Number(10), Constraint Employee_pk Primary Key (EmployeeID), -- sets primary key for table Constraint Employee_FK Foreign Key References ProjDept(ProjDeptID)-- identifies foreign key );

This is the second table in the script that won't work, the next 2 tables generate similar errors.

MT0 · Accepted Answer · 2019-11-09 01:19:49Z

4

You forgot to include the name of the column which is referencing another in the foreign key:

Create Table Employee ( EmployeeID Number(4) Not Null, FirstName VarChar2(15) Not Null, LastName VarChar2(20) Not Null, ProjDeptID Number(4) Not Null, PhoneNumber Number(10), Constraint Employee_pk Primary Key (EmployeeID), -- sets primary key for table Constraint Employee_FK Foreign Key (ProjDeptId) References ProjDept(ProjDeptID)-- identifies foreign key );

db<>fiddle

answered Nov 9, 2019 at 1:19

MT0

173k12 gold badges70 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kampe24 Over a year ago

I don't understand what you mean. I put that it referenced the ProjDept table and then the ProjDeptID column.

MT0 Over a year ago

@Kampe24 Compare your code Foreign Key References to my code Foreign Key (ProjDeptId) References. You stated that there is a foreign key and that it references to the PrejDeptID column of the ProjDept table but you did not state which column of the Employee table it is referencing from; that column name(s) need to be stated between the FOREIGN KEY and REFERENCES keywords.

Kampe24 Over a year ago

Wow I can't believe I missed that. Thanks for helping me out I was going crazy over that.

Littlefoot · Accepted Answer · 2019-11-09 05:56:52Z

Where exactly in Apex are you executing those commands?

If SQL Workshop's SQL Commands, then you can't have more than a single command in there, i.e. you should create tables one by one:

create the first table
delete that create table command and write another one, for the second table; then create it
the same goes for other tables as well

Alternatively, go to SQL Workshop's SQL Scripts and put all your commands into a script, e.g.

create table a (id number, name varchar2(20), ...); create table b (cdate date, ...);

save & run the script.

I'm writing them in the SQL Scripts section. The above answer worked but now I'm getting a different error. I have a table that has a composite key using 2 other primary keys from other tables and it won't let me do it saying the keys are already assigned to other tables.
Two options: drop "other tables" (if you don't need them), or (safer option) rename those constraints you're trying to create right now. If you want to check where those constraints are already used, query USER_CONSTRAINTS.

Collectives™ on Stack Overflow

Missing Parenthesis in Apex

2 Answers 2

3 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Related