CODEWITHSUNDEEP
oracle-sqldeveloperparentheses
Danielesk
Danielesk

Reputation: 127

Missing Right Parenthesis Oracle

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)
);

Upvotes: 2

Views: 7319

Answers (1)

Danny Beckett
Danny Beckett

Reputation: 20850

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.

Upvotes: 2

Related Questions