[b]方向递归查询：[/b]
SELECT * FROM CMS_ARTICLE_CATEGORY START WITH id = @id CONNECT BY PRIOR PARENT_ID = id
[b]递归查询[/b]
select * from CMS_ORG start with id = @id connect by prior ID = PARENT_ID
SELECT * FROM CMS_ARTICLE_CATEGORY START WITH id = @id CONNECT BY PRIOR PARENT_ID = id
[b]递归查询[/b]
select * from CMS_ORG start with id = @id connect by prior ID = PARENT_ID
扫一扫
121万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
