Error in SQL Statement (basic)

Question

I'm creating tables for a college excercise, but I keep getting an error executing the query and I can't find the error. SQL Developer is awful specifying it.

This is the SQL Developer output:

Error stating in line 58:
CREATE TABLE deportexevento(
  id_evento NUMBER NOT NULL,
  id_deporte NUMBER NOT NULL,
  CONSTRAINT pk_deportexevento PRIMARY KEY (id_evento, id_deporte),
  CONSTRAINT fk_evento_deportexevento
    FOREIGN KEY (id_evento)
    REFERENCES evento(id),
  CONSTRAINT fk_deporte_deportexevento
    FOREIGN KEY (id_deporte)
    REFERENCES deporte(id)
)

CREATE TABLE evaluador(
  cuil VARCHAR(15) NOT NULL,
  nombre VARCHAR(60) NOT NULL,
  email VARCHAR(60) NOT NULL,
  CONSTRAINT pk_evaluador PRIMARY KEY (cuil)
)
Error report -
Error SQL: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

Full SQL: https://pastebin.com/pfCz5Jwt

toonice · Accepted Answer · 2017-03-31 06:44:08Z

1

Try a semicolon after each of your create statements, as below...

CREATE TABLE deportexevento
(
    id_evento NUMBER NOT NULL,
    id_deporte NUMBER NOT NULL,
    CONSTRAINT pk_deportexevento PRIMARY KEY ( id_evento, id_deporte ),
    CONSTRAINT fk_evento_deportexevento
        FOREIGN KEY ( id_evento )
        REFERENCES evento( id ),
    CONSTRAINT fk_deporte_deportexevento
        FOREIGN KEY ( id_deporte )
        REFERENCES deporte( id )
);
CREATE TABLE evaluador
(
    cuil VARCHAR( 15 ) NOT NULL,
    nombre VARCHAR( 60 ) NOT NULL,
    email VARCHAR( 60 ) NOT NULL,
    CONSTRAINT pk_evaluador PRIMARY KEY ( cuil )
);

answered Mar 31, 2017 at 6:44

toonice

2,2541 gold badge16 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Antú Villegas Over a year ago

The output of SQL Developer doesn't print the semicolons, as you can see in the full SQL. Thought of pointing that out in the original post :P

toonice Over a year ago

All of your CREATE statements apart from deportexevento have semicolons after then in the full SQL.

Antú Villegas Over a year ago

Oh my god, though I checked that, so I discarded it. Thanks

Collectives™ on Stack Overflow

Error in SQL Statement (basic)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related