问题描述: 创建表test,目录id命名为id,父目录id命名为fu_id,名称为name oracle实现 SELECT ID,PATH FROM ( SELECT SYS_CONNECT_BY_PATH(NAME,'/') "PATH",CONNECT_BY_ISLEAF "ISLEAF",A.* FROM TEST A START WITH A.FU_ID IS NULL CONNECT BY PRIOR ID = FU_ID) WHERE ISLEAF = 1