`
wu00yu11
  • 浏览: 61087 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

根据最大版本执行语句

阅读更多
SET DEFINE OFF;
DECLARE
   ids   t_bpm_processdefine_info.processdefin_%TYPE;
   num   t_bpm_processdefine_info.processdefine_version%TYPE;
BEGIN
  
   SELECT MAX (processdefine_version)
     INTO num
     FROM t_bpm_processdefine_info
    WHERE processdefine_name = 'XMB7';

   SELECT processdefin_
     INTO ids
     FROM t_bpm_processdefine_info
    WHERE processdefine_name = 'GCJDJHBS330XB' AND processdefine_version = num;

update T_BPM_PROCESSDEFINE_INFO  set FOMR_SCRIPT = '
controlButton(''transmitDiv,setProcessButton,fileUploadsButton'');
'
where PROCESSDEFINE_NAME = 'XMB7' and PROCESSDEFIN_ = ids;

   COMMIT;
END;
/
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics