title: how to split a data of column in more than one column in oracle10g?
body: <p>We have table with 3 columns METRIC,count,SETS and  Data looks like:</p>
  
  <pre><code>            "METRIC"           "COUNT" "SETS"           
              FOR_PEOPLE_LIKE_ME      0   SET1
              FOR_YOUNG_PEOPLE        1   SET1
              GOOD_TASTE              0   SET1
              HIGH_SATISFACTION       2   SET1
              FOR_STATUS_ORIENTED     0   SET1
  
              FOR_PEOPLE_LIKE_ME      0   SET2
              FOR_YOUNG_PEOPLE        1   SET2
              GOOD_TASTE              0   SET2
              HIGH_SATISFACTION       0   SET2
              FOR_STATUS_ORIENTED     3   SET2
  </code></pre>
  
  <p>I want to split the data by "SET1" and "SET2".What approach should I
  use? My desired result is:</p>
  
  <pre><code>    "METRIC"             "SET1"   "SET2"
      FOR_PEOPLE_LIKE_ME      0         0    
      FOR_YOUNG_PEOPLE        1         1
      GOOD_TASTE              0         0    
      HIGH_SATISFACTION       2         0
      FOR_STATUS_ORIENTED     0         3
  </code></pre>