how to prevent default values on existing record
hi ,
i am using oracle 9i and i have an existing table
i have just added a new column col1 with default value 'N' and it seems that oracle automatically updates all existing record for that column with N.
i have thought that it should affect only subsequent records that are newly inserted w/o value for that column ?
is this the nature of Oracle & is there any way to prevent the updates on the new field of existing records?
pls advise