ALTER TABLE DADOSGERSPED ADD IDGERAREG0221 VARCHAR2(1) NULL
   CONSTRAINT CKC_IDGERAREG0221 CHECK (IDGERAREG0221 IS NULL OR (IDGERAREG0221 IN ('S','N')))
/

ALTER TABLE DADOSGERSPED DROP CONSTRAINT CKC_IDGERABLOCOK
/

ALTER TABLE DADOSGERSPED ADD CONSTRAINT CKC_IDGERABLOCOK CHECK (IDGERABLOCOK IN ('N','S','E','P'))
/