Just recently started learning SQL and got assigned some homework.
I have to make a few tables but I keep getting an ORA-00907 missing right parenthesis error but I see no syntax issues.
This is my code for one of the tables I have to make:
CREATE TABLE DRIVER
(
DRIVER# INT NOT NULL PRIMARY KEY,
DNAME VARCHAR(255),
SALARY INT,
CERT_DATE DATE,
DEPOT# INT FOREIGN KEY REFERENCES DEPOT(DEPOT#)
);