Oracle 可重复执行脚本例子

思路如下

DECLARE
  tmp INTEGER;
BEGIN

SELECT COUNT(1) INTO tmp FROM SYS.ALL_TAB_COLS WHERE OWNER = 'SYSDBA' AND TABLE_NAME = '表名大写' AND COLUMN_NAME = '列名大写';
IF (tmp = 0) THEN EXECUTE IMMEDIATE '
ALTER TABLE SYSDBA.表名 ADD 列名 VARCHAR(50);
';END IF;

END;