Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to change not null column to null ?

NicloeiWJul 17 2008 — edited May 18 2011

hi,

is there any way to change not null column to null ?

Create Table test
(a Number(10) Not Null,
 b Date
 );

i need column a to be nullable, can this be done ?

i am using direct load of data from .dat file 
in which first column i.e. a is null, 
hence i need to modify the table column 
definition so that column a is nullable.

plz assist

regards
nic

Message was edited by:
Nicloei W

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2011
Added on Jul 17 2008
7 comments
130,106 views