Some more Oracle SQL fun:

ALTER TABLE "SCHEMA_NAME"."TABLE_NAME"
ADD ("COLUMN_NAME" NUMBER(10) DEFAULT 1 NOT NULL)