Missing Right Parenthesis Oracle

Question

I am trying to create a table in SQL developer but I get an error saying:

Error SQL: ORA-00907: Missing Right Parenthesis.

Code:

CREATE TABLE PACIENTE (
    IdentificacionID integer(5),
    TipoIdentificacionID integer(5),
    Nombre varchar(30),
    Apellido varchar(30),
    NumeroHistoriaClinica integer(5)
);

Answer 1

Your problem is you're using INTEGER. You should be using NUMBER:

CREATE TABLE PACIENTE (
    IdentificacionID number(5),
    TipoIdentificacionID number(5),
    Nombre varchar(30),
    Apellido varchar(30),
    NumeroHistoriaClinica number(5)
);

I agree the error message is confusing though! Here's a SQLFiddle.