Are you certain the query is correct? Those must be truly huge numbers.
And why use (36,4)? Max precision available with native SQL types is 38 and there's no evident reason to double the scale. You could try DECIMAL(38,2) or NUMBER(*,2).
Hard to say based on what you've provided so far. The query entered above isn't valid SQL.
If that's the result you want, it seems like you could do a simple SUM of each column, then "unpivot" the resulting single row to columns.