pl/sql--connect by ;strat with的用法举例

1.创建表

create table hek_bom(
  master_id varchar2(20)
, master_name varchar2(50)
, sub_id varchar(20)
, sub_name varchar(20) )

2.插入数据

insert into hek_bom values('0001','V1卡车','10001','V1发动机');

insert into hek_bom values('0001','V1卡车','10002','V1车架');

insert into hek_bom values('0001','V1卡车','10003','V1车轮');

insert into hek_bom values('0002','V2卡车','10001','V1发动机');

insert into hek_bom values('0002','V2卡车','10002','V1车轮');

insert into hek_bom values('0002','V2卡车','10004','V2车架');

insert into hek_bom values('0003','V3卡车','10004','V1发动机');

insert into hek_bom values('0004','V4卡车','10005','V2发动机');

insert into hek_bom values('10001','V1发动机','10006','V1活塞');

insert into hek_bom values('10001','V1发动机','10007','V1火花器');

insert into hek_bom values('10007','V1活塞','10008','V1橡胶片');

insert into hek_bom values('10007','V1活塞','10009','V1螺丝');

3.查询

S