ORA-00907: missing right parenthesis Developer

1
votes

What could be the problem?

CREATE TABLE ASIGNACION_ANUAL(
ANIO NUMBER(4),
COD_VENDEDOR VARCHAR2(4),
MONTO_ASIGNACION NUMBER(9) NULL_MONTO,
CANT_VENTAS NUMBER(2) NULL_CANT_VENTAS,
CONSTRAINT ASIGNACION_ANUAL_PK PRIMARY KEY (ANIO, COD_VENDEDOR)
);

Error message:

ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis"

1
sqloracleoracle11gddlora-00907
@Hadi: please do not add the PLSQL if the question is not about PL/SQL - a_horse_with_no_name

1 Answers

2
votes

remove NULL_MONTO and NULL_CANT_VENTAS :

CREATE TABLE ASIGNACION_ANUAL (
ANIO NUMBER(4),
COD_VENDEDOR VARCHAR2(4),
MONTO_ASIGNACION NUMBER(9) NULL,
CANT_VENTAS NUMBER(2) NULL,
CONSTRAINT ASIGNACION_ANUAL_PK PRIMARY KEY (ANIO, COD_VENDEDOR)
)