amar on web

• home
• On Oracle database
• On Oracle Forms&Reports
• On Oracle iAS
• On linux
• On PMP certification
• My blog
• My Profile
• family link

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.

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

Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was created on 16-dec-2001 and last updated on 16-dec-2001.
please forward all queries to amar_padhi@fastmail.fm