oracle 树状结构数据库,Oracle树形汇总-connect_by_root

Oracle树形汇总--connect_by_root

有个需求：统计上级部门的销售额，制造数据如下：

drop table dept;

create table dept

(

DEPTNO number,

DEPTNAME varchar2(50),

PARENT_DEPTNO number

);

insert into dept values(1,'市场部',-1);

insert into dept values(2,'市场一部',1);

insert into dept values(3,'市场二部',1);

insert into dept values(4,'销售一组',2);

insert into dept values(5,'销售二组',2);

insert into dept values(6,'销售三组',3);

insert into dept values(7,'销售四组',3);

insert into dept values(8,'电力1',4);

insert into dept values(9,'电力2',5);

insert into dept values(10,'电力3',4);

insert into dept values(11,'电力4',5);

insert into dept values(12,'石油1',6);

insert into dept values(13,'石油2',7);

insert into