如何用SQL查询语句获取Oracle表 树形结构的记录（PL/SQL ）

 

例子：

select  /*+choose */  topic_id, lpad(' ',level*5,' ') || label, hotkeys
from
(select topic_id, hotkeys, label,parentid from ipop_topic where application_id=1008 and active=1 order by label) connect by parentid = prior topic_id
start with parentid = 0