
/*------ ATD 361266 ------*/
DECLARE v_count NUMBER(1) := 0; 
BEGIN 
SELECT COUNT(1) INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'PREVIA' AND Upper(column_name) = 'SELECAOFILIAL'; 
IF v_count = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE PREVIA ADD SELECAOFILIAL  VARCHAR(254) '; 
END IF;
END;





