CODEWITHSUNDEEP
databaseoracle-databaseaddition
user3469203
user3469203

Reputation: 547

ORA-00984: column not allowed here - Oracle database

I want to add a column on an existing table (ORACLE Database) :

ALTER TABLE FOA_PARAM_PRODUIT
ADD (LANCEMENT_RAPIDE_DEVIS          VARCHAR2    (1 CHAR)       DEFAULT N)
;

I got this error :

ADD (LANCEMENT_RAPIDE_DEVIS      VARCHAR2    (1 CHAR)   DEFAULT N)
                                                                        *
ERROR at line 2:
ORA-00984: column not allowed here

Here are my actuel table :

ID_PRODUIT  NUMBER(5,0)
ID_MARCHE   NUMBER(5,0)
ID_BRANCHE  NUMBER(5,0)
COD_PRODUIT VARCHAR2(200 CHAR)
LIB_PRODUIT VARCHAR2(200 CHAR)
TYP_DEBRANCHEMENT   VARCHAR2(20 CHAR)
COD_OAV VARCHAR2(10 CHAR)
NOM_OAV VARCHAR2(50 CHAR)
OPPORTUNITE_OBLIGATOIRE VARCHAR2(1 CHAR)
NOM_EXECUTABLE_OAV  VARCHAR2(20 CHAR)

I have no column named LANCEMENT_RAPIDE_OAV, is there anybody who can help ?

Upvotes: 0

Views: 2086

Answers (1)

user4399775
user4399775

Reputation:

Corrected command:

ALTER TABLE FOA_PARAM_PRODUIT ADD (LANCEMENT_RAPIDE_DEVIS VARCHAR2 (1 CHAR) DEFAULT 'N');

Upvotes: 2

Related Questions