title: Oracle : select maximum value from different columns of the same row
body: <p>The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns.</p>
  
  <p>For example, from this table </p>
  
  <pre><code>name m1 m2 m3 m4
  A    1  2  3  4
  B    6  3  4  5
  C    1  5  2  1
  </code></pre>
  
  <p>the result would be</p>
  
  <pre><code>name max
  A    4
  B    6
  C    5
  </code></pre>
  
  <p>The query must be compatible oracle 8i.</p>