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.
