[ad_1]
How to write the oracle sql query for tree structure like for example There is a parent node 500000, under this there is another parent 510000, and under this there are child nodes like 510001,520002 I need to get the sum of amounts for each child how to write query for this Main parent so that It can appear horizontally one by one all the childs under parents?
[ad_2]