declare cnt number;
begin
---查询要创建的表是否存在
select count(1)
into cnt
from cols
where table_name = upper('sys_CustomReport')
and column_name = upper('FConfig');
---如果存在则删除该表
if cnt<1 then
execute immediate 'ALTER TABLE sys_CustomReport ADD FConfig Blob';
end if;
end;
转载于:https://www.cnblogs.com/DKSoft/archive/2013/05/09/3068829.html