ALTER TABLE EMPRBANC ADD IDGERLINHACOBEMAIL VARCHAR2(01)
	CONSTRAINT CKC_IDGERLINHACOBEMAIL CHECK (IDGERLINHACOBEMAIL IN ('S', 'N'))
/
UPDATE EMPRBANC SET IDGERLINHACOBEMAIL = 'N' WHERE IDGERLINHACOBEMAIL IS NULL
/
COMMIT
/