ALTER TABLE FLAG 
      ADD (ASSIGNFLAGCANCELSCAN VARCHAR2(1) DEFAULT 'Y' NOT NULL
                                   CONSTRAINT YN_VALIDATIONNEW88
                                          CHECK (ASSIGNFLAGCANCELSCAN IN ('Y', 'N')));
