declare
v_rowcount integer;
begin
select count(1) into v_rowcount from user_tab_columns
where table_name=upper('表名')
and column_name=upper('字段属性名');
if v_rowcount=0 then
execute immediate 'alter table 表名 add 字段属性名 number(10) not null';
end if;
end;
/