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 阅读全文
posted @ 2018-11-19 11:22 凌心缘 阅读(245) 评论(0) 推荐(0)
摘要:--添加债券期限字段 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 阅读全文
posted @ 2018-11-16 16:08 凌心缘 阅读(1161) 评论(0) 推荐(0)