ALTER TABLE INSCRESTAD ADD IDENVBCSPEDGIA VARCHAR2(1) NULL
	CONSTRAINT CKC_IDENVBCSPEDGIA_INSC 
		CHECK (IDENVBCSPEDGIA IS NULL OR (IDENVBCSPEDGIA IN ('S', 'N')))
/
UPDATE INSCRESTAD
   SET IDENVBCSPEDGIA = 'S'
WHERE SGESTADO <> 'SP'
  AND IDUTCARGATRIB = 'S' 
  AND IDCREDDEBNORM = 'S'
/
COMMIT
/