Home » RDBMS Server » Server Administration » Error while adding not null constraint
Error while adding not null constraint [message #371077] Thu, 24 August 2000 00:58 Go to next message
Jaya Kumar NM
Messages: 11
Registered: August 2000
Junior Member
alter table emp add constraint nn_sal not null(sal)
the above statement gives me
"ORA-00904: invalid column name" error, please explain?
but it will accept
alter table emp modify sal not null
Re: Error while adding not null constraint [message #371083 is a reply to message #371077] Thu, 24 August 2000 09:03 Go to previous message
Thavamani
Messages: 11
Registered: July 2000
Junior Member
Hi,
Try out this.it works fine for me.
alter table test add (constraint nn_sal sal number(5) not null );
Previous Topic: Re: @corelated subquery
Next Topic: Sending Email Database through PL/SQL
Goto Forum:
  


Current Time: Thu Oct 22 05:04:02 CDT 2020