[size=medium][color=blue][b]根据父节点查询所有子节点:
SELECT t.object_id, SYS_CONNECT_BY_PATH(t.name,'/')as fullName
FROM ibs_company_dept T
where t.company_id=1000333
START WITH T.PARENT_ID= -1 CONNECT BY PRIOR T.OBJECT_ID =T.PARENT_ID
ORDER BY LEVEL DESC
从当前节点开始:
SELECT SYS_CONNECT_BY_PATH (mc, '/')
FROM flfl
START WITH ID = 6498
CONNECT BY PRIOR ParentId = ID;
列出当前节点的根节点。
在前面说过,根节点就是start with开始的地方。
SELECT CONNECT_BY_ROOT mc, flfl.*
FROM flfl
START WITH ID = 6498
CONNECT BY PRIOR ParentId = ID;
connect_by_root函数用来列的前面,记录的是当前节点的根节点的内容。
列出当前节点是否为叶子。
这个比较常见,尤其在动态目录中,在查出的内容是否还有下级节点时,这个函数是很适用的。
SELECT CONNECT_BY_ISLEAF, flfl.*
FROM flfl
START WITH ParentId IS NULL
CONNECT BY ParentId = PRIOR ID;
connect_by_isleaf函数用来判断当前节点是否包含下级节点,如果包含的话,说明不是叶子节点,这里返回0;反之,如果不包含下级节点,这里返回1。
[/b][/color][/size]
SELECT t.object_id, SYS_CONNECT_BY_PATH(t.name,'/')as fullName
FROM ibs_company_dept T
where t.company_id=1000333
START WITH T.PARENT_ID= -1 CONNECT BY PRIOR T.OBJECT_ID =T.PARENT_ID
ORDER BY LEVEL DESC
从当前节点开始:
SELECT SYS_CONNECT_BY_PATH (mc, '/')
FROM flfl
START WITH ID = 6498
CONNECT BY PRIOR ParentId = ID;
列出当前节点的根节点。
在前面说过,根节点就是start with开始的地方。
SELECT CONNECT_BY_ROOT mc, flfl.*
FROM flfl
START WITH ID = 6498
CONNECT BY PRIOR ParentId = ID;
connect_by_root函数用来列的前面,记录的是当前节点的根节点的内容。
列出当前节点是否为叶子。
这个比较常见,尤其在动态目录中,在查出的内容是否还有下级节点时,这个函数是很适用的。
SELECT CONNECT_BY_ISLEAF, flfl.*
FROM flfl
START WITH ParentId IS NULL
CONNECT BY ParentId = PRIOR ID;
connect_by_isleaf函数用来判断当前节点是否包含下级节点,如果包含的话,说明不是叶子节点,这里返回0;反之,如果不包含下级节点,这里返回1。
[/b][/color][/size]