select level,t.valuecode,t.valuepcode,t.valuename from (select * from ngo_dict_value a where a.dictcode = '007') t start with t.valuecode = '00' connect by t.valuepcode = prior t.valuecode order by level,t.valueorder
level ,和connect by 是oracle自带的
select level,t.valuecode,t.valuepcode,t.valuename from (select * from ngo_dict_value a where a.dictcode = '007') t start with t.valuecode = '00' connect by t.valuepcode = prior t.valuecode order by level,t.valueorder
level ,和connect by 是oracle自带的