declare
cnt integer;
begin
select count(0)
into cnt
from user_tab_columns a
where a.table_name = upper('bp3_bank_account')
and a.column_name = upper('Depositbank_No');
if cnt = 0 then
execute immediate 'alter table bp3_bank_account add Depositbank_No VARCHAR2(512)';
execute immediate 'comment on column bp3_bank_account.Depositbank_No is ''建行超级网银银行代码''';
end if;
end;
oracl给表新增字段
最新推荐文章于 2022-04-14 13:54:16 发布