
/*------ ATD 232399 ------*/
/* PA 232399 (Kopell) */
DECLARE v_Count NUMBER(1) := 0;
BEGIN
SELECT 1 INTO v_Count FROM USER_TAB_COLUMNS WHERE UPPER(TABLE_NAME) = UPPER('CFOSaidCad') AND UPPER(COLUMN_NAME) = UPPER('BaseExcedente');
EXCEPTION
WHEN NO_DATA_FOUND THEN
EXECUTE IMMEDIATE 'ALTER TABLE CFOSaidCad ADD BaseExcedente NUMBER(15,2) DEFAULT 0 NOT NULL';
END;
DECLARE v_Count NUMBER(1) := 0;
BEGIN
SELECT 1 INTO v_Count FROM USER_TAB_COLUMNS WHERE UPPER(TABLE_NAME) = UPPER('CFOEntrCad') AND UPPER(COLUMN_NAME) = UPPER('BaseExcedente');
EXCEPTION
WHEN NO_DATA_FOUND THEN
EXECUTE IMMEDIATE 'ALTER TABLE CFOEntrCad ADD BaseExcedente NUMBER(15,2) DEFAULT 0 NOT NULL';
END;
COMMIT;