Im trying to create a table but I keep getting the error not

I`m trying to create a table but I keep getting the error notice \"ORA-00942 TABLE OR VIEW DOES NOT EXIST. Is there anything wrong with my Query?

CREATE TABLE Erik_Morataya

( employee_number int NOT NULL,

employee_name char(50) NOT NULL,

department_id int,

salary int,

address varchar2(50),

CONSTRAINT employees_pk PRIMARY KEY (employee_number),

CONSTRAINT fk_departments,

FOREIGN KEY (department_id),

REFERENCES departments (department_id),

);

Solution

CREATE TABLE Erik_Morataya
( employee_number int NOT NULL,
employee_name char(50) NOT NULL,
department_id int,
salary int,
address varchar2(50),
CONSTRAINT employees_pk PRIMARY KEY (employee_number),
CONSTRAINT fk_departments FOREIGN KEY (department_id) REFERENCES departments (department_id)
);

This is the right query for table creation. last 3 statements should not be comma seperated. this is single statement to add foreign key.

I`m trying to create a table but I keep getting the error notice \

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site