SQL & PL/SQL

A B C D E F G total1
AA 1 2 3 4 5 6 7 28
BB 2 2 3 4 5 6 7 29
CC 3 4 5 6 7 8 7 40
DD 4 3 4 5 6 7 7 36
total2 10 11 15 19 23 27 28 133
How do I write a sql (oracle and t-sql) which would help me sum up the rows and columns . Thanks