1 Reply Latest reply: Mar 24, 2013 12:47 PM by FlyingGuy RSS

    How convert a row to column with plsql

    okKarol
      Hi,
      Am facing an ... issue with my code

      I've this table

      ID DATA_KEY
      ----------------------- -------------------------------------------------
      3437651551 channel
      3437651551 Device Identifier
      3437651551 processId
      3437651551 currencyCode


      I need to create a code to convert all this records into a table like :

      ID COL1 COL2 COL3 COL4
      3437651551 channel Device Identifier processId currencyCode


      Thxs
      I appreciate your help