This discussion is archived
1 Reply Latest reply: Mar 24, 2013 10:47 AM by FlyingGuy RSS

How convert a row to column with plsql

okKarol Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points