通过 connect_by_isleaf 伪劣来判断该节点是否为叶子节点,如果是叶子节点则查询出来为1, 不是则为0。
使用方法:直接在connect by prior 语句中将此伪劣放入select 后即可。
例子:
select connect_by_isleaf, level levels, rownum rn, t.*
from t_tree t start with t.id = ‘40’ connect by prior t.id= t.parentid;
通过 connect_by_isleaf 伪劣来判断该节点是否为叶子节点,如果是叶子节点则查询出来为1, 不是则为0。
使用方法:直接在connect by prior 语句中将此伪劣放入select 后即可。
例子:
select connect_by_isleaf, level levels, rownum rn, t.*
from t_tree t start with t.id = ‘40’ connect by prior t.id= t.parentid;