使用rownum
--修改个人编号
update sys_user t set t.user_no = 17020000+rownum,t.user_work_no = 17020000+rownum where t.user_no is null;
使用rownum
--修改个人编号
update sys_user t set t.user_no = 17020000+rownum,t.user_work_no = 17020000+rownum where t.user_no is null;