Question: how to calculate sum of two columns in oracle?
Answer: You could create a virtual column that adds up your 96 columns, something like: alter table TABLEA add (MY_TOTAL_COL NUMBER GENERATED ALWAYS AS (col1+col2+col3...) VIRTUAL); Then your query can simply do sum(my_total_col) .