删除某一带序号的数据后重新排序的SQL

UPDATE CBS_APP_IM_INSPECTBODY A SET A.G_NO=(SELECT ROW_NUM FROM (SELECT ROWNUM ROW_NUM,B.CODE FROM CBS_APP_IM_INSPECTBODY B WHERE B.FCODE='" + hidCode.Value + "'
ORDER BY B.G_NO DESC) C WHERE C.CODE=A.CODE) WHERE A.FCODE='" + hidCode.Value + "'