Article From:https://www.cnblogs.com/blogsaspx/p/9969903.html

–Add bond maturity field

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;

/

Leave a Reply

Your email address will not be published. Required fields are marked *