读书人

依据最大版本执行语句

发布时间: 2012-07-22 19:31:17 作者: rapoo

根据最大版本执行语句
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;
/

读书人网 >其他数据库

热点推荐