How to add not null colum in the table which contains 10 million records
840912Apr 21 2011 — edited Feb 19 2012I want to add two not null columns in table
but the table contains 10 million records
tell me the most efficinet way
Iam using the following
ALTER TABLE STAFF ADD INSURANCE_PROVIDER Varchar2(35) default 'ABC';