declare
cnt integer;
begin
select count(1) into cnt from user_tab_cols a where a.table_name=upper('XXX') and a.column_name =upper('XXXXX');
if cnt = 0 then
execute immediate 'alter table xxx add XXXX varchar2(32)';
end if;
end;
/
Oracle 插入一列 幂等写法 如果不存在则插入
最新推荐文章于 2023-03-30 09:55:07 发布