Oracle Database Discussions

All,

I want to add one column in existing table with default value.but I don't want apply the default value in the existing rows.

It should be apply for only new rows that is going to be add.. how I can achieve this?

I have tried this one, but it updated the existing rows too...

alter table emp1 add num number default 10;

Thanks in advance.