Re: ADD columns

These are the rules for adding a column to a table:

1. You may add a column at ANY time if NOT NULL isn't specified.
2. You may add a NOT NULL column in three steps:
3. Add the column without NOT NULL specified
4. Fill every row in that column with data
5. Modify the column to be NOT NULL

Hope this helps.

Josue

In article <LvJh3.2817$8v6.218574_at_carnaval.risq.qc.ca>,   "Mr.X" <pandore_at_itr.qc.ca> 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
>
>

--
ABC Tech Solutions
http://www.abcsolutions.org
[Java/Oracle/Linux] [C/S & Internet Database Apps]

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 10 1999 - 19:13:31 CDT