2 Replies Latest reply: Dec 6, 2012 11:26 AM by Osama_Mustafa RSS

    oracle 10g query rows to column transpose

      In oracle 10g I have table called LoginUser

      Select * from LoginUser where Day = '01-Dec-2012'

      will give me the below result

      Day, Name, Country
      1-Dec-12 , John, UK
      1-Dec12 , Cate, US
      1-Dec-12 , Prakash, India
      1-Dec-12 ,Juli, Pak

      But I want result as below

      Day, Name1, Country1, Name2, Country2, Name3, Country3, Name4, Country4
      1-Dec-12, John, UK, Cate, US, Prakash, India, Juli, Pak

      Please help

      Edited by: 975340 on Dec 6, 2012 1:48 AM

      Edited by: 975340 on Dec 6, 2012 1:50 AM