RE>Not Null Syntax ---

From: Dong, Paul <DONGP_at_USSURG.COM>
Date: Tue, 16 Jan 1996 13:51:02 -0500
Message-Id: <9601162053.AA05242@alice.jcc.com>

RE>Not Null Syntax ---
 Gregory,

 You just redefine the column specification to be as nullable (NULL) rather  than NOT NULL, i.e.,

 ALTER TABLE [tablename] MODIFY ([columnname] [datatype] NULL);

 I'm not sure if the [datatype] is required, but I have found that Oracle  does not complain when it is specified.

• Paul Dong

  ---

 Date: 1/16/96 12:43 PM
 To: Paul Dong

 From: list., ORACLE dm
 From: ORACLE database mailing list.
 Date: Tue, Jan 16, 1996 12:43 PM

 Subject: Not Null Syntax ---
 To: Dong, Paul; list., ORACLE dm
 What is the syntax for removing a not null constraint from a column...

 The ALTER TABLE pages in the manual say it can be done but do not show the  syntax.

 Thanks. Received on Tue Jan 16 1996 - 15:53:34 CST