vendredi 2 janvier 2015

Having troubles creating table SQL


I'm new to SQL and Im trying to create a simple database, but I'm having problems with second one, I'm using Oracle Database express 11 and when I try to run this code I get error: Missing right parenthesis



CREATE table "CURSOS" (
"Nombre_curso" VARCHAR2(20) UNIQUE,
"Cod_curso" VARCHAR2(10),
"Apellido2" VARCHAR2(15),
"NIF_Prof" VARCHAR2(9),
"Max_al" INT (2),
"Fecha_ini" DATE,
"Fecha_fin" DATE,
"Horas" INt(6) NOT NULL,
constraint "CURSOS_PK" primary key ("Cod_curso"),
constraint "CURSOS_CK" CHECK (Fecha_ini<Fecha_fin),
constraint "CURSOS_FK" FOREIGN KEY (Nif_Prof) REFERENCES PROFESORES,
)




Aucun commentaire:

Enregistrer un commentaire