添加字段的脚本

/添加字段脚本/
DECLARE
num NUMBER;
BEGIN
SELECT COUNT(1)
INTO num
from cols
where table_name = upper(‘T_GLVOUCHERFM_DEL’)
and column_name = upper(‘acalelement06’);
IF num = 0 THEN
execute immediate ‘alter table T_GLVOUCHERFM_DEL add acalelement06 NUMBER(9)’;
END IF;
END;
/

转载自：https://blog.csdn.net/waei08/article/details/78256812