Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ADD columns

ADD columns

From: Mr.X <pandore_at_itr.qc.ca>
Date: Sat, 10 Jul 1999 15:19:07 GMT
Message-ID: <LvJh3.2817$8v6.218574@carnaval.risq.qc.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US