Hi guys,
Could you plz check this code out and tell what the problem is.
Thanks in advance
CREATE TABLE RESERVATIONS (
RESERVATION_ID NUMBER(5),
RENTER NUMBER(6),
CAR_TYPE NUMBER(1),
START_DATE DATE DEFAULT SYSDATE,
FINISH_DATE DATE,
TO_PAY NUMBER(6),
CONSTRAINT RESERVATIONS_PK PRIMARY KEY(RESERVATION_ID),
COSNTRAINT RESERVATIONS_FK1 FOREIGN KEY(RENTER) REFERENCES CLIENTS(CLIENT_ID),
CONSTRAINT RESERVATIONS_FK2 FOREIGN KEY(CAR_TYPE) REFERENCES CATEGORIES(CATEG_ID));
********************
COSNTRAINT RESERVATIONS_FK1 FOREIGN KEY(RENTER) REFERENCES CLIENTS(CLIENT_ID),
*
ERROR at line 9:
ORA-00907: missing right parenthesis