Re: Not Null Column in a existing table....

From: Boris Oblak <borisoblak_at_hotmail.com>
Date: Sun, 17 Oct 1999 07:16:30 +0200
Message-ID: <7ubm42$lp7$1_at_pamir.k2.net>


I think, that this is only way on Oracle7:

alter table my_table add column my_column; update my_table set my_column = my_value; alter table modify column my_column not null;

--
LP Boris

e-mail:boris.oblak_at_k2.net

Pankaj Joshi <pankaj_joshi_at_hotmail.com> je v sporočilu novic
7u9oth$6h3$1_at_news.vsnl.net.in napisal ...

> Hi Folks,
> Can anyone guide me.....how to add a column with not null constraint in a
> populated table without affecting the data.
>
> Thanks in advance,
>
> Pankaj
>
>
Received on Sun Oct 17 1999 - 07:16:30 CEST

Original text of this message