11 2018 档案
摘要:--(新增一条数据)Declare cnt Number;Begin Select count(*) into cnt From T_IM_MESSAGE_TEMPLATE WHERE S_TEMPLATE_ID = 'SBI-1227'; IF cnt = 0 Then insert into T
阅读全文
摘要:--添加债券期限字段 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_na
阅读全文