A m Z o n e

Adding DEFAULT and NOT NULL together for a column

I am trying the following command on a table. Will this work?

   alter table am10 add( mno varchar2(10) not null default 'x'); 

No. Oracle gives an error 'missing right parenthesis' which is misguiding.
This command will work only if DEFAULT clause is put before NOT NULL.

Press the Back button of you Browser to go to previous page
Home