PROTECTED]]
Sent: Wednesday, May 23, 2001 4:57 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Drop 'NOT NULL' Constraint
I think that if there is already data in the column you will not be able
to
do that.
-Original Message-
Sent: Wednesday, May 23, 2001 5
I think that if there is already data in the column you will not be able to
do that.
-Original Message-
Sent: Wednesday, May 23, 2001 5:15 PM
To: Multiple recipients of list ORACLE-L
I created a table with a 'NOT NULL' constraint on a VARCHAR2 column. I
would like to remove the NOT
On Wed, 23 May 2001, Chris Rezek wrote:
I created a table with a 'NOT NULL' constraint on a VARCHAR2 column. I
would like to remove the NOT NULL constraint. I've tried a couple of
'ALTER TABLE' commands but no luck.
How does one do this?
alter table foo
modify (bar null);
Cheers,
GC
--
http://www.superpages.com
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 4:57 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Drop 'NOT NULL' Constraint
I think that if there is already data in the column you