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

Report message to a moderator

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 );

Report message to a moderator

Previous Topic: Re: @corelated subquery
Next Topic: Sending Email Database through PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 29 18:24:49 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.