BOM 结构如图
-- 1DH142-022 （DRIVE)
-- 100729421 (PCBA)
-- 100764148 (HDA)
-- 100687050 (VCM)
-- 100701274 (COVER)
-- 100741904 (HSA)
ORACLE 递归语句
select parent_assembly, child_component, site_name, level From scpdata.scp_pbom start with parent_assembly = ‘1DH142-022‘ connect by prior child_component = parent_assembly;
原文：https://www.cnblogs.com/gongzhenhua/p/12091322.html