Bismillah

Hi Guang !

You Can Use :

alter table test modify ( id constraint id_nn not null );

Best Regards

Your DBA

Salman Faheem






"Cale, Rick T (Richard)" <RICHARD.T.[Email Address Removed] on 08/31/2001 08:32:30
PM

To: "LazyDBA.com Discussion" <[Email Address Removed] RE: why this command does not work?


alter table test MODIFY (id_nn not null);

Rick

-----Original Message-----
From: Guang Mei [mailto:[Email Address Removed] Friday, August 31, 2001 10:21 AM
To: LazyDBA.com Discussion
Subject: why this command does not work?


Hi,

A quick question.

This code works:
create table test ( id number constraint id_nn not null);

This also works:
create table test ( id number);
alter table test modify id not null;

But this one (the 2nd line) gave me error:
create table test ( id number);

SQL> alter table test add constraint id_nn not null (id);
alter table test add constraint id_nn not null (id)
*
ERROR at line 1:
ORA-00904: invalid column name


So what is the correct syntax for that?

TIA.

Guang

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html





Oracle LazyDBA home page