SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLSQL aggegations with addition and Subtraction

srivMar 27 2019 — edited Mar 27 2019

Hi All,

I have below input table with members in Parent/Child format with aggregation and data present at Level-0 members.

Can some one help with PL/SQL code to aggregate data to the upper level members based on the aggregation symbol for each row.

Input Table:

Parent	Child	Level	Aggregation	Data
Top	ACC	2	+
ACC	ACC1	1	+
ACC1	ACC1_1	0	+	400
ACC1	ACC1_2	0	+	350
ACC1	ACC1_3	0	-	150
ACC	ACC2	1	-
ACC2	ACC2_1	0	+	50
ACC2	ACC2_2	0	+	150

Output Table:

Parent	Child	Level	Aggregation	Data
Top	ACC	2	+	400
ACC	ACC1	1	+	600
ACC1	ACC1_1	0	+	400
ACC1	ACC1_2	0	+	350
ACC1	ACC1_3	0	-	150
ACC	ACC2	1	-	200
ACC2	ACC2_1	0	+	50
ACC2	ACC2_2	0	+	150

Added on Mar 27 2019

#sql

3 comments

282 views