missing paranthesis

[kuzen]

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_FK 1 FOREIGN KEY(RENTER) REFERENCES CLIENTS(CLIENT_ ID),
CONSTRAINT RESERVATIONS_FK 2 FOREIGN KEY(CAR_TYPE) REFERENCES CATEGORIES(CATE G_ID));
*************** *****
COSNTRAINT RESERVATIONS_FK 1 FOREIGN KEY(RENTER) REFERENCES CLIENTS(CLIENT_ ID),
*
ERROR at line 9:
ORA-00907: missing right parenthesis

[duraisamy]

Hi,

while writing syntax please chek it your keyword spell.what mistake u made is COSNTRAINT instead of CONSTRAINT. Take care your self don't confuse This will happen for every one.
by duraisamy.