1 Reply Latest reply: Apr 26, 2012 8:59 AM by 924529 RSS

    converting columns into rows

    924529
      Hi All,

      I need a logic for to convert columns into rows. I have multiple columns they will as one row. I'm giving the sample data below. Is there any can we do this using unpivot or any other analytical function. Please help me out.
      SELECT 'FRANCE' ,'USA','UK','FR100' FRAN_CODE,'102020' US_OCDE,'2032' US_CODE FROM DUAL;
      
      COUNTRY CODE
      ======= ====
      FRANCE  FR100
      USA      102020
      UK        2032
      Thanks a lot.

      Regards,
      Ramana.