oracle sql 数结构表id降序

UPDATE BAS_ORGANIZATION_TYPE T1
SET T1.PARENTID=(
select rn from (
SELECT id,rownum rn FROM BAS_ORGANIZATION_TYPE T2 )a
where a.id=t1.parentid);

update bas_organization_type set id=rownum;