ALTER TABLE RUPTURAOL ADD CDSUBGRPROD VARCHAR2(1500)
/

ALTER TABLE RUPTURAOL ADD CDGRUPPROD VARCHAR2(10)
/

ALTER TABLE RUPTURAOL ADD CDROTATRANS VARCHAR2(1500)
/

ALTER TABLE RUPTURAOL ADD IDAUTOFORNEX VARCHAR2(1)
/

ALTER TABLE RUPTURAOL ADD IDEMEXECUCAO VARCHAR2(1) NULL    
    CONSTRAINT CKC_RUPTURAOL_IDEMEXECUCAO  CHECK (IDEMEXECUCAO IS NULL OR (IDEMEXECUCAO IN('S', 'N')))
/

ALTER TABLE RUPTURAOL ADD QTRETORNAPEN NUMERIC 
/