单表:
select t.typeId,t.typeName,t.parentId from t_data t
start with t.typeId = 3
connect by prior t.typeId = t.parentid
关联表:t_ues_pic_rescategory目录表,t_ues_resource 资源表 关联列categoryId
该语句实现递归查询某个目录(包括子目录)下所有资源
select r.*, tp.categoryname
from t_ues_resource r,
(select t.categoryid, t.categoryname
from t_ues_pic_rescategory t
start with t.categoryid = 27
connect by prior t.categoryid = t.parentid) tp
where r.categoryid = tp.categoryid
order by r.uploadtime desc