title: using decode in query multiple results?
body: <pre><code>SELECT PE.PHYS_RESR_ID,PE.EQMT_INIT,  PE.EQMT_NBR,
  decode (EEU.dimn_type , 'EXTHGT', EEU.dimn_valu) as EXTHGT, 
  decode(EEU.dimn_type, 'EXTHGT', EEU.uom_code) as UNIT_EXTHGT,
  decode (EEU.dimn_type , 'INHGT', EEU.dimn_valu) as INHGT, 
  decode(EEU.dimn_type, 'INHGT', EEU.uom_code) as UNIT_INHGT,
  decode (EEU.dimn_type , 'INWDTH', EEU.dimn_valu) as INWDTH, 
  decode(EEU.dimn_type, 'INWDTH', EEU.uom_code) as UNIT_INWDTH
  
  FROM EQU_EQMT PE
    left join EQU_EQMT_DIMN EEU 
    on  EEU.PHYS_RESR_ID = PE.PHYS_RESR_ID      
  and   ( EEU.POS_DESC is null or EEU.POS_DESC ='VALU' or EEU.POS_DESC ='valu');
  </code></pre>
  
  <p>But when i run it. the query returns me a line for each decode i make. and i want a line for this id pe.phys_resr_id with the different data in the same line. Any advice ?
  I would like it to give me like this:</p>
  
  <pre><code>+-------------+-------------+---------+--------+------------+---------+------------+------------+---------------+
  | PHYS_RESR_ID| EQMT_INIT   | EQMT_NBR| EXTWD  | UNIT_EXTWD | INHGT   | UNIT_INGHT | INWDTH      | UNIT_INWDTH  | 
  +-------------+-------------+---------+--------+------------+---------+------------+-------------+--------------+
  |  456        | AC          | 3       |   4    |   IN       | NULL    | NULL       | NULL        | NULL     | 
  |  324        | AD          | 45      |   67   |   IN       | 56      | IN         | NULL        | NULL     |
  |  132        | B           | 65      |  54    |   IN       | 78      | IN         | 34          |  IN      |    
  +----+-------------+---------+--------+--------+------------+---------+------------+-------------+--------------+
  </code></pre>