ALTER TABLE PROJECT ADD (
  NOTIFY_ISSUE_OPENING VARCHAR2(1) DEFAULT 'N' NOT NULL, 
  PRODUCT_TYPE VARCHAR2(1) DEFAULT 'I' NOT NULL
)
/
ALTER TABLE PROJECT ADD CONSTRAINT CKC_PROJECT_PRODUCT_TYPE CHECK (PRODUCT_TYPE in ('I','G','C'))
/
ALTER TABLE PROJECT ADD CONSTRAINT CKC_PROJ_NOTIFY_ISSUE_OPENING CHECK (NOTIFY_ISSUE_OPENING in ('Y','N'))
/