是否为末的物料分类,判断如下
select mbc.pk_marbasclass,
mbc.code,
mbc.name,
level as rank,--层级
decode(connect_by_isleaf, 1, 'Y', 'N') as is_leaf --是否叶子(末级)节点 1是 0否
from bd_marbasclass mbc where nvl(mbc.dr, 0) = 0
start with nvl(mbc.pk_parent, '~') = '~' --开始条件
connect by mbc.pk_parent = prior mbc.pk_marbasclass; --递归条件