向jg表中初始化字段pxh,使用本表中dm排序号每一行的rownum,可使用如下代码
update t_xt_jg jg1
set pxh = (select rn
from (select ord.id, rownum rn
from (select jg2.id from t_xt_jg jg2 order by jg2.dm) ord) t
where t.id = jg1.id);