Adding a column with a default value to an existing table.

[JMac]

Actually played around and did following, which worked fine without updating the table with 'N' values.

ALTER TABLE xxxxx
ADD col_name VARCHAR2(1);

ALTER TABLE xxxxx
ADD constraint con_name_chk CHECK (xxxxx IN ('Y','N'));

Which gives me the advantage of getting to name the constraint.

The default value it seems was not a business rule, but a developer's idea.