mengtianyalll的专栏

原创 oracle树形结构查询

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