Re: ADD columns

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 11 Jul 1999 20:40:55 +0800
Message-ID: <378890D7.5B94@yahoo.com>

Paul J. McGlew wrote:
>
> alter table table_name add (etat_exp boolean, etat_exs boolean);
> (replace "table_name" with the name of your table.)
>
> "Mr.X" wrote:
>
> > 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

I don't think boolean is a supported table data type...although anything like number (1 or 0 ) or char (y or n, y or null etc etc ) will suffice...

Cheers
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jul 11 1999 - 07:40:55 CDT