DECLARE cnt INT;
BEGIN
SELECT count(1) INTO cnt FROM USER_TAB_COLS WHERE TABLE_NAME = 'RP_AGTSVRCNT' AND COLUMN_NAME = 'SUMSVRDUR';
IF (cnt = 0)THEN
EXECUTE IMMEDIATE 'ALTER TABLE Rp_AgtSvrCnt ADD(SUMSVRDUR INTEGER)';
cnt :=0;
END IF;
SELECT count(1) INTO cnt FROM USER_TAB_COLS WHERE TABLE_NAME = 'RP_AGTSVRCNT' AND COLUMN_NAME = 'SUMWORKDUR';
IF (cnt = 0)THEN
EXECUTE IMMEDIATE 'ALTER TABLE Rp_AgtSvrCnt ADD(SUMWORKDUR INTEGER)';
cnt :=0;
END IF;
END;