ORACLE获取BOM清单

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