ALTER TABLE CLIENTE ADD IDGARANTCLIE VARCHAR2(01) NULL
   CONSTRAINT CKC_IDGARANTCLIE CHECK (IDGARANTCLIE IN ('1','2','3','4','9'))
/
ALTER TABLE CLIENTE ADD IDGRAUGARANT VARCHAR2(02) NULL
   CONSTRAINT CKC_IDGRAUGARANT CHECK (IDGRAUGARANT IN ('1','2','3','4','99'))
/
ALTER TABLE CLIENTE ADD DTVALIDGARANT DATE NULL
/
ALTER TABLE CLIENTE ADD VRGRANTCLIE FLOAT NULL  