Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ADD columns
how can I add a column to a table without loosing everithing ?
I want to add two columns : etat_exp and etat_exs both (boolean or char)
That is my table :
SERIE_DOC NUMBER(2) NOT NULL, NO_SOUS_SERIE NUMBER(3) NOT NULL, NO_SS_SOUS_SERIE FLOAT NOT NULL, LETTRE_DOC CHAR(1) NOT NULL, TEMPS_ACTIF_P NUMBER(2), TEMPS_SEMI_ACTIF_P NUMBER(2), DATE_CREATION_DOC DATE, DATE_FIN_ACTIF_P DATE, DATE_FIN_SEMI_ACTIF_P DATE, TEMPS_ACTIF_S NUMBER(2), TEMPS_SEMI_ACTIF_S NUMBER(2), DATE_FIN_ACTIF_S DATE, DATE_FIN_SEMI_ACTIF_S DATE, DESC_DESCRIPTION VARCHAR2(100), DIVISION VARCHAR2(50), NO_SEQUENCE_DOC NUMBER(3) NOT NULL, DESTIN_STATUS_P CHAR(1), DESTIN_STATUS_S CHAR(1), DESCRIPTEURS VARCHAR2(100),
Thanx ! Pat Received on Sat Jul 10 1999 - 10:19:07 CDT
![]() |
![]() |