title: Total sum of multiple columns in Oracle SQL Statement by unique ID
body: <p>I have a table of members_id and Flags . I want to sum up how many flags a member_id has (like below). I have about 19 Flags which can have a 1 or 0 in the flag field . So basically I want to sum up the 1 in each column per Member_Id</p>
  
  <pre><code>Member_Id | Flag2| Flag3| Flag4|Flag5|Flag6|Flag7|Flag8|
  999999b     1        0      0    0     1       1      1    
  777777a     0        1      1    0     1       0      0
  </code></pre>
  
  <p>Desired Result </p>
  
  <pre><code>Member_Id |  Total
  999999b        4
  777777a        3
  </code></pre>