0 Replies Latest reply on Nov 16, 2012 5:36 AM by 972471

    Oracle 10g Query Format


      down vote
      favorite I am using oracle 10g. I have a temp table TEMP.

      TEMP has following structure:-

      1 10 T1

      2 21 T2

      3 45 T1

      1 7 T1

      I need a query which will show all types has column names,and types can be any value like T1,T2,..Tn and columns will be like:-

      USER T1 T2 Tn
      and User column will show all the users and T1,T2 column will show total count of types.

      Edited by: 969468 on Nov 15, 2012 9:35 PM