mybatis 处理in 1000以上sql
摘要：展开查看 点击查看代码 ``` update T_XSGL_XSXX_XJXX xjxx set xjxx.XWZSBH = null, xjxx.ZHXGR = #{userId}, xjxx.ZHXGSJ = sysdate where exists(select 1 from T_BYGL_X
阅读全文
posted @ 2023-06-14 18:48
06 2023 档案
oracle 之存储过程 begin ...... ; ...... end
摘要：点击查看代码 ``` begin merge into ly_yjs_hxsj.T_XSGL_XSXX_CZRZ rz using ( select a.XS_ID xsid, xh, xm, '02' as bglx,'修改学生：'||xm||':学位操作撤销学位证书号，原学位证书号：'|| BJ
阅读全文
posted @ 2023-06-09 11:08
