ORA 分组排序并更新序号

SELECT  ROW_NUMBER () OVER ( PARTITION BY REG_NO,MZ_FLAG,BL_TYPE ORDER BY BL_ORDER,BL_TIME  ) CNO,BL_ORDNO,REG_NO,MZ_FLAG,BL_TYPE,BL_ORDER
FROM EMR_PATIENT_BL_NEW    
where MZ_FLAG=‘#‘

update EMR_PATIENT_BL_NEW b set b.BL_ORDER=(
with t as
(select ROW_NUMBER () OVER ( PARTITION BY REG_NO,MZ_FLAG,BL_TYPE ORDER BY BL_ORDER,BL_TIME  ) CNO,BL_ORDNO
FROM EMR_PATIENT_BL_NEW  t  
where MZ_FLAG=‘#‘ )
select a.CNO from t a where a.BL_ORDNO=b.BL_ORDNO
)