oracle树形结构查询

select dm_id, father_id, dm_name from gy_dmcode t
where level  <= 2    --层级
start with t.dm_id = '0' --根节点
connect by prior t.dm_id = t.father_id;  --定义关系，prior 表示优先级