
/*------ ATD 396390 ------*/
/*------ ATD 396390 ------*/
DECLARE v_count NUMBER:=0;
BEGIN

SELECT Count(1) INTO v_count FROM USER_TAB_COLUMNS WHERE UPPER(table_name) = 'PONTORETIRADAMERCADORIA' and UPPER(column_name) = 'NOMEECOMMERCE';
IF v_count = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE PONTORETIRADAMERCADORIA ADD NOMEECOMMERCE VARCHAR(254) NOT NULL DEFAULT('')';
END IF;

commit;
END;