--添加债券期限字段
declare
cn integer;
begin
cn := 0;
select count(*)
into cn
from user_tab_cols t
where t.table_name='T_BANK_BOND_MARKET_SET'
and t.column_name ='B_LEVEL_ISSUE';
if cn =0 then
execute immediate ' ALTER TABLE T_BANK_BOND_MARKET_SET ADD (B_LEVEL_ISSUE VARCHAR2(10))';
end if;
end;
/