查询树结构数据

SELECT to_char(LEVEL), market_troop_no, market_troop_no_up, troop_name FROM tmm_market_troop WHERE bureau_no = sBureauNo AND state = '1' CONNECT BY PRIOR market_troop_no = market_troop_no_up START WITH (market_troop_no_up = '0' OR market_troop_no_up IS NULL) ORDER BY LEVEL asc;