–查找表中是否存在该列,存在返回1,不存在返回0
select count(1) from cols where table_name = upper(‘INV_PCP_ACCOUNTDEPT’) and column_name = upper(‘ID’)
–查找表中是否存在该列,存在则不执行execute语句,不存在则新增该字段
DECLARE
num NUMBER;
BEGIN
SELECT COUNT(1)
INTO num
from cols
where table_name = upper(‘INV_PCP_ACCOUNTDEPT’)
and column_name = upper(‘POST’);
IF num < 1 THEN
execute immediate ‘alter table dgh_6.inv_pcp_accountdept add post varchar2(50 BYTE)’;
END IF;
END;