Re: compute sum on VACHAR column

To sum up counts, you can use the rollup option in the group by clause.
As in Select gender,count(*) from ... group by rollup(gender). Have you looked at the decode function ? You could do something like ...
Select sum (Male), sum(Female),

          sum(Male+Female), sum(Male)/sum(Male+Female) from (select decode(gender,'M',1,0) Male, decode(gender,'F',1,0) Female

         from ... where ...) T_in
Note that you don't have to use an inline query, but it simplifies the logic Received on Wed Apr 19 2006 - 11:39:16 CDT