是否为末级的物料分类,判断如下:
select mbc.pk_marbasclass,
mbc.code,
mbc.name,
level as rank,
decode(connect_by_isleaf, 1, 'Y', 'N') as is_leaf --connect_by_isleaf为1时表示为末级
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;