'Newbie here: ORA-00907 help me identify? [closed]

CREATE TABLE PROJECT(
                      PROJECT_ID           INT PRIMARY KEY,
                      CUSTOMER_ID          INT REFERENCES CUSTOMER(CUSTOMER_ID),
                      PROJECT_DESCRIPTION  VARCHAR(30),
                      PROJECT_DATE         DATE, 
                      ESTIMATED_START_DATE DATE,
                      ESTIMATED_END_DATE
                      ESTIMATED_BUDGET     NUMBER(9,2), 
                      ACTUAL_START_DATE    DATE,
                      ACTUAL_END_DATE      DATE, 
                      ACTUAL_COST          NUMBER(9,2),
                      MANAGER_ID           INT REFERENCES EMPLOYEE(EMPLOYEE_ID)
                    );

I am doing an SQL project and I am missing a right parenthesis, I can't actually quite seem to see where I am missing one.

sqloracle


Solution 1:[1]

You missed to provide the data type for the column ESTIMATED_END_DATE. It should be something like ESTIMATED_END_DATE DATE, similar to ESTIMATED_START_DATE DATE. And of course, there is needed a comma after this since further columns follow.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions