alter table add column with default value
snippet in sql

alter table add column with default value

user5053

ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)

add column alter table default value

user3815

ALTER TABLE PERSON
ADD IS_ACTIVE VARCHAR2(1) DEFAULT 'N' NOT NULL