hey peeps i am new to sql and have created the following table in my database but get the following error(below), where am i going wrong?



)
*

ERROR at line 11:
ORA-00905: missing keyword


CREATE TABLE Staff_table
(
StaffNo INT NOT NULL,
Name VARCHAR(40) NOT NULL,
Address VARCHAR(255) NOT NULL,
Salary INT NOT NULL,
DOB TIMESTAMP(6) NOT NULL,
OfficeNo INT NOT NULL,
PRIMARY KEY(StaffNo),
FOREIGN KEY(OfficeNo)
);

For Foreign key it should be

FOREIGN KEY contraint_name (OfficeNo) REFERENCE table_name (Col name)