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>
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 ...Received on Sun Oct 17 1999 - 07:16:30 CEST
> 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
>
>