下面写的这个sql语句可以实现的功能是:显示数据库中,数据之间的层次关系(比如部门所属),同时把层次的数目也可以表示出来。
SELECT
DEPART_CODE,
DEPART_NUMBER,
DEPART_BELONG,
LEVEL,
SYS_CONNECT_BY_PATH(DEPART_CODE,'/') "PATH"
FROM
DEPART
START WITH DEPART_CODE = 1 CONNECT BY PRIOR DEPART_CODE = DEPART_BELONG
ORDER BY DEPART_CODE
文章首发:www.webkkk.net